topic Re: DM_GWPipeline_Gateway_DataSourceAccessError in Developer

DM_GWPipeline_Gateway_DataSourceAccessError

lnoguera — Mon, 12 Jul 2021 22:34:04 GMT

Hello people, we have a web app we use to show our reports to our staff and one of them suddenly started to fail showing the data since last week.

Our app uses the Power BI C# SDK in the backend to get the access token and embed token using service principal. The backend code is not throwing any errors and the embed token is correctly got. In the frontend, we are using the Javascript SDK and when we call powerbi.embed(reportContainer, config); the report starts loading and after some seconds it shows the report blanked, with no data.

While trying to debug this error we found that there´s a 403 error in the browser

We added an on error handler to see if we got any details and we got this:

detailedMessage: "undefined. Could not render a report visual titled: undefined" message: "DM_GWPipeline_Gateway_DataSourceAccessError" technicalDetails: {requestId: undefined}

This report uses an on-premise live connection to an SSAS instance through a report gateway. The report and the gateway is working fine when we open it in the power bi app (desktop and app.powerbi.com), it loads correctly and shows the data. We have verified that the user we are using to connect to the SSAS data source is an admin in the SSAS instance. Do you have any ideas on what could be the cause for this issue? Thanks in advance.

Re: DM_GWPipeline_Gateway_DataSourceAccessError

Anonymous — Thu, 15 Jul 2021 09:37:03 GMT

Hi @lnoguera

I found some official documents for gateway troubleshooting and embed troubleshooting, please kindly refer to

Troubleshooting your Power BI embedded analytics application - Power BI | Microsoft Docs

Troubleshoot gateways - Power BI | Microsoft Docs

Solved: Power BI Embedded "OpenConnectionError," "Can't di... - Microsoft Power BI Community

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: DM_GWPipeline_Gateway_DataSourceAccessError

Anonymous — Thu, 18 Aug 2022 08:05:05 GMT

Could you able figure this out? I am also facing the same issue but my on-premise gateway is in an EC2 instance.

Re: DM_GWPipeline_Gateway_DataSourceAccessError

lnoguera — Thu, 18 Aug 2022 15:36:33 GMT

Unfortunatelly no! we opened a support ticket because everything looked fine on our side but they weren't able to help us, so we ended up creating another version of the report that doesn't use an on-premise live connection to SSAS and uses a direct connection to SQL Server instead.