Privacy error - please rebuilt this data combination

[giuliapiazza94]

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

[ibarrau]

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,

[giuliapiazza94]

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]

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

[v-zhangti]

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.