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

Gnanasekar Have you opened the desktop and validated the query? I don't know what broke, but it could just require a re-publish of the Desktop after you've confirmed the logic hasn't changed.

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