Forum Discussion

ulysseshubner's avatar
ulysseshubner
Frequent Visitor
1 year ago

DM_GWPipeline_Gateway_MashupDataAccessError (Information is needed in order to combine data)

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, Ex...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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

ulysseshubner's avatar
ulysseshubner
Frequent Visitor
1 year ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    Power BI Service.  Not gateway. Service.

    • ulysseshubner's avatar
      ulysseshubner
      Frequent Visitor
      1 year ago

      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's avatar
        lbendlin
        Icon for Super User rankSuper User
        1 year ago

        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.