Forum Discussion

Gnanasekar's avatar
Gnanasekar
Helper III
8 years ago
Solved

Cannot connect to the mashup data source

Dear All,   In my PowerBI service have 15 reports and it is connected through gateway with SQL database. Last two weeks only Fours reports are not refreshed. If I refreshed manually, it display e...
Need Help
Tutorial Requests
  • Gnanasekar's avatar
    Gnanasekar
    8 years ago

    Hi Anonymous

     

    Thank you for reply.

     

    It is working well in PowerBI desktop. Both are same. no logic was changed.

    I found root cause. I am not assign database directly in source step of the report. After I given database in source step in the report, this error was gone away.

     

     

     

     

MartinF's avatar
MartinF
Frequent Visitor
7 years ago

We have a similar issue. We are getting the same error message for the scheduled refresh of a few Power BI Datasets in the Power BI Service. But the strange thing is the on demand refresh works mostly in Power BI Service but the scheduled refresh fails always. There also only a few datasets affected. All others (with same or other data sources) works fine.

Our data sources are SQL Server relational database and SSAS Multidimensional. We tried already differenct time windows for the scheduled refresh but it does not matter.

 

Does anyone any ideas what could be the reason.

 

Thanks and best regards,

Martin

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Did anyone find a fix to their issue around this? I am also getting an error (cannot connect to mashup datasource) when trying to refresh a report in the service. The source is a SQL database and it refreshes fine in desktop.
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Please let me know if anyone finds this solution. I am getting the "cannot connect to the mashup data source" error as well. This is for my scheduled refresh on the web service.