Forum Discussion
Privacy error - please rebuilt this data combination
Hi guys,
I have this problem when I try refresh on PBI web
The data come from SQL server and the last step is a group by.
Why is there a privacy error? The other reports, that use the same data set, work.
The refresh on PBI desktop works
4 Replies
Hi. By default Power Bi Privacy Levels is set to Combine data according to your Privacy Level settings. Be sure that both of the sources that are merged have the same privacy level. You can use Organizational
https://powerbi.microsoft.com/it-ch/blog/privacy-levels-for-cloud-data-sources/
I hope that helps,
When I use gateway I have this
I use two data sources in my report:
1- excel that is ok
2- sql server database
Both are the same privacy level (organizational)
The tables that are merged belong to the same sql server database so I don't know why it is a problem
Hi, giuliapiazza94
Have you tried to re-merge your data sources?
Prerequisites:
-
A gateway installed on a local computer.
-
A Power BI Desktop file with queries that combine on-premises and cloud data sources.
On the Dataset settings page for the new dataset:
- For the on-premises source, select the gateway associated with this data source.
- Under Data source credentials, edit the cloud data source credentials, as necessary.
Make sure privacy levels for both cloud and on-premises data sources are set appropriately to ensure the joins are handled securely.
This is the relevant document, hope to help you:
https://docs.microsoft.com/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
https://community.powerbi.com/t5/Desktop/Error-please-rebuild-this-data-combination/m-p/738795
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
