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 someh...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity 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.