Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Helper IV
4 years ago

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 d...
Need Help
giuliapiazza94's avatar
giuliapiazza94
Helper IV
4 years ago

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-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.