Forum Discussion

LeDuc's avatar
LeDuc
Frequent Visitor
4 years ago

Incremental Refresh causes an error in PBI services

I set up Incremental Refresh on the Power BI desktop and refreshed the data and it worked fine. But when I published the data on the web app, it failed with the following log. It seems like PBI somehow added these symbols `` on every column name so Dremio couldn't parse the query. Help is appreciated. Thanks

 

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [HY000] [Dremio][Connector] (1040) Dremio failed to execute the query: select `PK`,\r\n `MONTH`,\r\n `COMPANY_ID`,\r\n `COMPANY_CODE`,\r\n

Need Help

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi LeDuc ,

     

    Generally speaking, this may be a privacy level issue. You can change the permissions of the dataset from "None" to "Organization" in powerbi destkop and republish it to the service, then you need to go to the "Management Gateway "and make sure the "Privacy Level" of this data source is also "Organization".

    For more details, you can read related blog link:

    Privacy Levels for Cloud Data Sources | Microsoft Power BI Blog | Microsoft Power BI


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • LeDuc's avatar
      LeDuc
      Frequent Visitor
      4 years ago

      Hello Henry, thank you so much for the help.

      Just to make sure I've followed exactly as you instructed. I have to:

      1. Go to Data source settings -> Edit Permissions -> change Privacy Level to Organizational
      2. Go to PBI services -> Manage gateways -> change Privacy Level setting for this data source to Organizational

      Is this correct? If so I've done it and the error persists

       

      Is there anything else I can try? Thanks.