Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Please help me on schedule refresh error

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailN...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

gabimuenster Thanks for the reply.

 

1.I have used SQL query for connecting database to power bi with the credentials. 

2.For other reports also(query based) I have used the same database and credentials to connect which are refreshing succesfully without any error.

 

*Only 1 report is showing the given error

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
4 years ago

Have your added the SQL server to your gateway? If you upload a new pbix report with SQL connection query, you need to add the sql server to the gateway. In the printscreen below, I have loaded a new pbix file, it won't get refreshed because the sql server is not mapped to any data source in my gateway. If you have the same issue, try to add the sql server to your gateway first.