Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DM_GWPipeline_Gateway_MashupDataAccessError On-Premises Data Gateway Error

Hello,   So I have a dataset published in the Service that has the following data sources:   https://tenders.nsw.gov.au/ https://www.tenders.act.gov.au/tender/search https://www.tenders.wa.gov...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

If you are getting an error from the clients VM it is very possible that it does not have access to the Power BI Service.

Ask them to open HTTPS from the VM to the internet?
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello! The client's VM and production machine can access all the data source websites, as well as app.powerbi.com

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    Can I know whether the account for logging in to Power BI Service and the gateway of the production environment machine are same as those of the laptop? In addition, what are the relevant gateway and power bi service regions? You can refer the following documentations about how to get the region of gateway and Power BI Service.

    Get gateway datacenter region

    Get Power BI Service region

    Best Regards

    Rena

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

    • OB's avatar
      OB
      Icon for Helper II rankHelper II
      6 years ago

      Hi Is there a Permament solution to this issue?  It's been an issue for our team since last week - nothing has changed on our end, but reports stopped refreshing in PBI Service giving errors about credentials and mashup.  Someone else posted a separate issue today and I described our issues in detail there https://community.powerbi.com/t5/Service/Credential-Missing/m-p/1289813#M105497. 

       

      As Elwiraa mentioned in her reply to this post , we also used DAX for Union and it worked, but there were other transformations applied to the Append table in Power Query, so it would be desirable to see this work again instead of recreating the whole report with DAX.