Windows 10: Power BI issues with functions

Discus and support Power BI issues with functions in Windows 10 Updates and Activation to solve the problem; Hello, I am having issue. How to solve it? DataSource.Error: ODBC: ERROR [42601] ERROR: syntax error at or near "[";Error while executing the... Discussion in 'Windows 10 Updates and Activation' started by name12359, Sep 1, 2021.

  1. name12359 Win User

    Power BI issues with functions


    Hello, I am having issue. How to solve it? DataSource.Error: ODBC: ERROR [42601] ERROR: syntax error at or near "[";Error while executing the queryDetailsPower BI issues with functions :DataSourceKind=OdbcDataSourcePath=database=name;driver={PostgreSQL Unicodex64};port=5869server=125.26.8.6OdbcErrors=[Table] Here is content of function via advanced editor:Source= Odbc.Query"driver={PostgreSQL Unicodex64};server=152.25.100.20;port=3486database=name", ....

    :)
     
    name12359, Sep 1, 2021
    #1
  2. Paolo Mag Win User

    Power BI

    Hello James,

    This issue with using Power BI requires advanced technical assistance. For you to get the most appropriate resolution, we suggest that you post your concern in our
    Power BI Community. From there, our team from Power BI who specializes with this software will assist you.

    Let us know if you need further help with any Windows issue.
     
    Paolo Mag, Sep 1, 2021
    #2
  3. Microsoft Power BI Service not allowing RLS function

    Thanks for the suggestion Ganesh,

    But here we need to use the best way that the customer should not able to view the filtering style and this URL method filtering:?filter=Tablename/Fieldname eq 'Value' is not working with the report links in power bi service.
     
    Niranjan (MS Developer), Sep 1, 2021
    #3
  4. Power BI issues with functions

    Microsoft Power BI Service not allowing RLS function

    I surfed through blogs to understand about URL filtering method in power bi. But even though I follow all steps to implement the reports to be filtered in Power bi Service, am unsuccessful in it(not working).

    My doubts :

    1. Do I need to be a Power BI Pro license user? - If yes, of course, I am a pro user and still not able to do it in PBI Service.

    2. Do I need to get some additional settings to be enabled in it? - Correct me if I am wrong.

    My Question :

    1. Is there any other steps to filter out the reports in PBI Service other than Option setting parameters and URL filtering method - Please suggest me the best way to implement.

    2. Do I need to update versions of PBI Service - Currently it is in Version13.0.8383.170.
     
    Niranjan (MS Developer), Sep 1, 2021
    #4
Thema:

Power BI issues with functions

Loading...
  1. Power BI issues with functions - Similar Threads - Power issues functions

  2. The problem with registering in power bi

    in Windows 10 Software and Apps
    The problem with registering in power bi: Good afternoon, I can't register with power bi, when I enter a phone number, then, sorry, we need additional information to confirm your identity. What should I do to register and have my phone missed?...
  3. Download Power BI Destop

    in Windows 10 Software and Apps
    Download Power BI Destop: I have just started the process of downloading Power BI Destop from the following website:Downloads Microsoft Power BII have selected the "Advanced Download Options"I selected the English version I am Australian and everything is in EnglishI selected the x64 version to...
  4. Download Power BI Destop

    in Windows 10 Installation and Upgrade
    Download Power BI Destop: I have just started the process of downloading Power BI Destop from the following website:Downloads Microsoft Power BII have selected the "Advanced Download Options"I selected the English version I am Australian and everything is in EnglishI selected the x64 version to...
  5. Power BI Pro subscription issue

    in AntiVirus, Firewalls and System Security
    Power BI Pro subscription issue: Hi i am GeorgeMy Company is AlphaAd and during January i paid for a Power BI Pro subscriptionwith the order No Order number: 64544078-e37c-4819-bcdf-71a6b8a19004I want to cancel my subscription but it seems that this is impossible even to login.I go to the first email i...
  6. Power BI Help

    in Windows 10 Gaming
    Power BI Help: Hi, I need someone to help me in Power BI, I need to calculate how many months have no sales for each row? https://answers.microsoft.com/en-us/windows/forum/all/power-bi-help/d9c653bc-bc32-45aa-8413-8c8d0f012d86
  7. Power BI Help

    in Windows 10 Software and Apps
    Power BI Help: Hi, I need someone to help me in Power BI, I need to calculate how many months have no sales for each row? https://answers.microsoft.com/en-us/windows/forum/all/power-bi-help/d9c653bc-bc32-45aa-8413-8c8d0f012d86
  8. High DPI Scaling Issue with Power BI Desktop

    in Windows 10 Drivers and Hardware
    High DPI Scaling Issue with Power BI Desktop: I've started experiencing a high DPI scaling issue for the past two months with just one app on Windows 10 20H2, which ironically is developed by Microsoft: Power BI Desktop. I have HP Elitebook 840 G3 laptop connected to Eizo monitor with 2560x1440 resolution and 150%...
  9. Sign-in for Power BI

    in Microsoft Windows 10 Store
    Sign-in for Power BI: I run my own business and while I have consultants working for me, I don't have a website so I don't have a "business" email address. My business email address is an @outlook.com.au email. I want to explore the functions of Power BI as if it works how I believe it will work,...
  10. Microsoft Power BI Service not allowing RLS function

    in Windows 10 Network and Sharing
    Microsoft Power BI Service not allowing RLS function: I surfed through blogs to understand about URL filtering method in power bi. But even though I follow all steps to implement the reports to be filtered in Power bi Service, am unsuccessful in it(not working). My doubts : 1. Do I need to be a Power BI Pro license user? - If...