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.
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?
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)
