Forum Discussion
Privacy error - please rebuilt this data combination
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
- v-zhangti4 years agoCommunity Support
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.
-
- v-zhangti4 years agoCommunity Support
Hi, giuliapiazza94
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards