Forum Discussion

Gnanasekar's avatar
Gnanasekar
Icon for Helper III rankHelper 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.

     

     

     

     

Gnanasekar's avatar
Gnanasekar
Icon for Helper III rankHelper III
8 years ago




 Hi Anonymous

 

Please specify the database during source configuration with SQL.

It will help to solve your error.

 

By 

Gnanasekar 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dear All,

 

I am having a similar issue while refreshing my report on Web with a connection to  a HANA database.I  am able to refresh it on Power BI Desktop but getting the error "connection string used for mash up datasource is invalid" on web.

 

Any valuable inputs from experts is greatly appreciated.

 

Regards,

Veena.