Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError On-Premises Data Gateway Error
Helper IIAnonymous
To clarify, I am going through the root connection. What I meant by sub-sites is, for example
The Desktop file has a separate connection to each site, then the two sources are appended by applying steps in Transform Data and the refresh works, but it didn't work in PBI Service using one gateway connection to the http://abc/sites/def/
So we created two gateway connections in PBI Service, one for http://abc/sites/def/AAA and one for http://abc/sites/def/BBB
Then we mapped each source to its own connection and the refresh worked in PBI Service.
This is how gateway connections would look like for the above sources:
Data Source Name AAA Data Source Type SharePoint Data Source URL Authentication Windows | Data Source Name BBB Data Source Type SharePoint Data Source URL Authentication Windows |
Hi OB ,
Hope you are doing well.
I am facing the same issues while refereshing my data in PBI Servie . Below is the screenshot for the same.
If you have the solution Could you be please help what needs to be done?
Thanks,
Ashish
- OB
Hi Ashish,
Your case is different from what I had. You have two different sources, one SAP HANA and one SharePoint Online. My issue was with two Shareoint on prem sources.
I would recommend troubleshooting the following: connect from PBI Desktop to only one source at a time, then publish that report, and then see if the refresh in PBI Service works. So check each source separately. It could be that the password changed or that the firewall has been updated in your company and blocked the PBI Service connection. Many options here, so further testing is required.
Sorry, I can't help more without additional info.
OB