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.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What do you mean by "assign database directly in source step"?  How did you correct the query?  I'm having the same issue. The refresh works in Power BI, but won't refresh via the schedule.  The error says it can't find a table.  Thanks!

Gnanasekar's avatar
Gnanasekar
Helper 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.