DM_GWPipeline_Gateway_MashupDataAccessError (Information is needed in order to combine data)

[ulysseshubner]

When I refresh Power BI Desktop everything goes well (no errors), but in automatic refresh (Power BI Service) the following problem occurs:

There are two types of data sources, Excel Sharepoint Online with Organizational privacy level and the other Web API with Anonymous and Public privacy level. This update used to work, but it didn't work on this specific panel, can someone help me, please?

[Anonymous]

Hi, @ulysseshubner 

The case of the same problem as yours has been resolved. The end result is that the issue is not about privacy settings, but about models and queries.
You should check your queries in Power BI desktop to make sure they merge properly.

Best Regards

Jianpeng Li

[Anonymous]

Hi, @ulysseshubner 

Merry Christmas to you. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
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

[lbendlin]

Check your settings again, looks like you didn't specify all of the privacy levels.

[ulysseshubner]

You talk about Power BI Desktop Data Configuration or Power BI Service (Gateway)?

[lbendlin]

Power BI Service.  Not gateway. Service.

[ulysseshubner]

This has all privacy settings, the error occurs when I merge a sharepoint abla with a web api source table, if I remove the merge, it updates normally

[lbendlin]

The 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.

[ulysseshubner]

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

[Anonymous]

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.