Forum Discussion
Error message on refresh- Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacySetting
Hello everyone!
This error is happening to me and my BI team with some datasets on Power Bi Service:
Underlying error code: -2147467259
Underlying error message: La información se necesita para combinar los datos
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"UTP-LIMPRODBS19.grupoutp.net;BD_CRM"},{"kind":"PowerBI","path":"PowerBI"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: 80da84ff-6afa-4d47-a178-d2776ac075be
Request ID: b5e291ea-31cb-cfd3-12d6-358ff15be067
Time: 2021-06-28 07:25:07Z
The dataset is currently using this gateway:
as you can see, the gateway brings data from our SQL Server datawarehouse.
The connectios that are used seem to work fine:
"SQL CRM"
"Puerta 20"
"CRM 3"
However, there is a connection called "PowerBi" which i think is referring to the dataflows used in the dataset. There is an error message that says "Cannot be aded to gateway". I am not sure if these messages are related.
I have read some simmilar messages posted by other users and tried some workarounds provided, but i still haven't found any solution.
please help me.
Hi UTP_user
The error is because the Privacy settings are different in the different data sources.
I would suggest try setting the privacy settings on all the data sources to be "Organizational"