Forum Discussion
mashup data source error in gateway (only) refresh
Much to my dismay, the promised gateway changes that were expected to address this failed to do so and my specific issue was ultimately deemed by Microsoft as unsupported by the gateway. My workaround was to completely redesign my approach to identifying the reporting period in a less than ideal hack.
This is still an issue. We're receiving the same error today.
Gateway and Power BI desktop are both updated.
Hi all,
I had a call with Microsoft, they asked me to put privacy level to PRIVATE in the desktop, re-publish, then set privacy = PRIVATE in the PBI online service too (in the gateway settings we're using).
It solved the issue.
Cheers,
F.
Hi, I have tried this with Organisational as my privacy but it does not work. should i go and try with Private ? Also, below is my error message in service to refresh the datasource.
Underlying error message: [Unable to combine data] Section1/Actual_Ordered Speed/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"Test;Test"},{"kind":"Web","path":"pathofmyurl"}] Hope to get some helpful answer on this !!!.
I also have a mashup error on some of my refresh in powerbi service with my gateway (i have a cluster of 3 servers).
The 3 nods on my cluster were update last week with the last version of the gateway.
Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
- Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"chg-dataws;datastore"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: rls UserPermissionsMapping.
- Cluster
- Activity
- Request
- Time2020-03-27 15:51:51Z
Anyony can help?
Hi I had the same problem.
I got message: UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}}
And it was connected to how I combine the data. In power query I couldnt merge data form table (data from computer disc C) and form different table (form jira or from sharepoint) even privacy level was the same.
I just didnt merge this data in power query, I did it in DAX by "related", and then refresh is working ok.
fhendrick's solution worked for me. Error I had was: "Microsoft.Data.Mashup.MashupSecurityException.Reason"
(edited for clarity)Thanks for your response. I changed the privacy level on the desktop and cloud and it worked. (from organizational to private)
I really appreciate this answer; it worked for me. I have been working on this problem for a long time, and I have finally found a solution. Thank you once again.
