Forum Discussion

UTP_user's avatar
UTP_user
Regular Visitor
5 years ago
Solved

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"

     

     

1 Reply

  • 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"