cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RGI Regular Visitor
Regular Visitor

Something went wrong ... ReasonPrivacyError

I'm getting this error when trying to refresh a dataset

 

Something went wrong
Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code-2147467259 Table: <table>.
Underlying error message[Unable to combine data] <....> references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources[{"kind":"Teradata","path":"database"}]
Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacyError
Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity <id>
Request <id>
Time2018-11-14 17:00:48Z

 

Any ideas?

9 REPLIES 9
v-jiascu-msft Super Contributor
Super Contributor

Re: Something went wrong ... ReasonPrivacyError

Hi @RGI,

 

Please share the IDs. I can find something in the log database. 

According to the error messages, I would suggest you change the privacy level. Please refer to the snapshot below. 

Something-went-wrong-Reason-Privacy-Error1

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RGI Regular Visitor
Regular Visitor

Re: Something went wrong ... ReasonPrivacyError

These are the IDs:

 

Activity IDb852608a-938e-413d-b874-66f4e89d1238
Request IDcb14abaf-6b27-46ec-a74d-cf5adf2d4274
 
I'll try your suggestion, although I believe the developer that just left already tried that. He managed to refresh the data using his personal gateway, but it's failing on the enterprise gateway.
RGI Regular Visitor
Regular Visitor

Re: Something went wrong ... ReasonPrivacyError

Setting the privacy to none made no difference.

Any other suggestions?

v-jiascu-msft Super Contributor
Super Contributor

Re: Something went wrong ... ReasonPrivacyError

Hi @RGI,

 

Can you share the Power Query code in the Query Editor? 

What are the data sources?

The IDs are too old. I only find that it kept saying Personal gateway isn't available. 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RGI Regular Visitor
Regular Visitor

Re: Something went wrong ... ReasonPrivacyError

This is the latest error message:

 

Something went wrong
Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code-2147467259 Table: Departments.
Underlying error message[Unable to combine data] Section1/Departments/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources[{"kind":"Teradata","path":"Db"}]
Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacyError
Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity IDb5961221-9cf8-4c92-a6e6-a8146d507d2d
Request ID88694e27-61d5-1016-8aef-febcecdf8b12
Time2018-11-19 17:09:24Z

 

There are many querys - and it seems to fail randomly in different places.

 

v-jiascu-msft Super Contributor
Super Contributor

Re: Something went wrong ... ReasonPrivacyError

Hi @RGI,

 

Did you add any columns in the Query Editor, which query other data sources? 

I would suggest you troubleshoot it by deleting the combined queries first. 

I didn't find anything useful in the log. 

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
RGI Regular Visitor
Regular Visitor

Re: Something went wrong ... ReasonPrivacyError

I'll have to wade through the code to understand it ... not my own. I normally use an abstract layer in a database and for production report prefer to bring spreadsheets into the database.

Rayno Frequent Visitor
Frequent Visitor

Re: Something went wrong ... ReasonPrivacyError

Hi There,

I've got a similiar problem,

 

A college has shared an excel document from their one drive for business and shared it with me. The link takes me to the sharePoint destination.

 

The excel document has been successfully imported with a working custom function to find the addresses from lat's and long's ( 
-22.338304000000001,30.042366999999999) | PowerBI Desktop

I used the web connection to the excel document as per,
https://www.youtube.com/watch?v=t4TzHu8THoA 


This all works perfectly on the PowerBI desktop but keeps failing in the PowerBI cloud service.


From my understanding both sources are external
1.) SharePoint (which is the onedrive saved location)
2.) Google API call to retieve  

The following additional steps where test
1.) Non Staged Query 
Works perfectly on PowerBI desktop | Fails in the PowerBI Cloud Service

This is the error from the PowerBI Cloud Service:
##[Unable to combine data] Section1/Query1/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination##

2.) Staged Query as per https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ 
Works perfectly on PowerBI desktop | Fails in the PowerBI Cloud Service
This is the error from the PowerBI Cloud Service:
##[Unable to combine data] Section1/Sheet1 (2)/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination##

3.) Excel document was moved to sharedfolder + to "c:\PorjectFolder\data.xlsx | Both results are as follows
Works perfectly on PowerBI desktop | Fails in the PowerBI Cloud Service
This is the error from the PowerBI Cloud Service: Note - A Personal gateway was used and this is a NON Staged data query.

-2147467259 Table: Sheet1.
Underlying error message:[Unable to combine data] Section1/Sheet1/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259


Conclusion:

It all works via PowerBI Deskop and fails on PowerBI cloud.

External sources                                                                 | Failed
Moved source to a local folder via the personal gateway | Failed

Rayno Frequent Visitor
Frequent Visitor

Re: Something went wrong ... ReasonPrivacyError

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 56 members 1,137 guests
Please welcome our newest community members: