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
gabimuenster's avatar
gabimuenster
Microsoft Employee
4 years ago

Hi Anonymous,

thanks for reaching out. Please let me make sure I understand properly:
With the same database, you mean the SQL database you used as data source for your Power BI dataset?
And with other reports, you mean reports not connected to the dataset, that had refresh issues, but with their own datasets?
If both assumptions are correct, the only explanation I have is that you are using different objects from the same SQL database. Please check if you are using all of the objects you are using in the erronous dataset also in the datasets, that are refreshing successfully.
If one or both of the assumptions are incorrect, please explain in more detail.

  • 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
      Power 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.