Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError for scheduling a report refresh in PowerBI online
Getting DM_GWPipeline_Gateway_MashupDataAccessError for scheduling a report refresh in PowerBI online. We are trying to refresh the report dataset from the data source using an API through On Premise Data Gateway.
[ValidateMarkupTags]<ccon>{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"[ccon]-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[ccon]Web.Contents failed to get contents from 'https://lqcapi.dev-us.osdu-apps.ssw.shell/api/v1/report?key=lqcwebsheetreport' (500): Internal Server Error[/ccon][/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"RestAPIOAuthConnector"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"
1 Reply
Hi tnvsskishore - I would recommend trying the Power Query inside a Dataflow rather that a Dataset. This will give you more visibilty of the error within the Power BI Web Service. When you are developing a Dataset it will be within Power BI Desktop you may not see this error. It is likely to be credentials related. You may need to go to "manage gateways and connections" to remove the credentials in the Web Service.
