Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError (Information is needed in order to combine data)
Super UserThe merge likely fails because the privacy settings do not match between these two sources.
Generally your approach of merging a SharePoint source with a Web API source is a VBI (Very Bad Idea) as you now require a gateway for both sources, including the SharePoint. And it is an irreversible process - from here on you can never not use a gateway for the sharepoint even if you remove the merge.
Don't do it. Don't merge in Power Query. Let the Power BI data model do the join for you.
but I need to add and merge queries, this type of configuration has already worked, I have panels running in this format, but this specific one has a problem
Thank you lbendlin
Hi, ulysseshubner
I see a similar case with a similar error as yours:
Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1
Here are some ideas to rule out this issue:
1. Try changing the privacy levels set at the time of gateway connection to be consistent to check if the issue is caused by the privacy settings at the gateway level.
2. Check the privacy level set by the report data source and try to change them to be consistent to rule out privacy settings issues with the report.
3. If none of the above check for issues, try copying your query into Power BI Service dataflow to see if it works and refreshes. to rule out issues inherent in the report itself.If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.