Forum Discussion

VigneshVs's avatar
VigneshVs
Frequent Visitor
9 years ago
Solved

Scheduling Error: "cannot connect to the mashup data source"

Hi Everyone,   I am using Enterprise gateway and have scheduled multiple dashboards for refresh but only a dashboard popping out an error in the Power BI Service. Whereas the same dashboard is gett...
Need Help
Show and Tell
Tips and Tricks
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi VigneshVs,

     

    In your scenario, which data source did you connect to in your report? Based on my research, there is something wrong in Power BI Service currently. You can see from Power BI support site.

     

    Best Regards,
    Qiuyun Yu

     

     

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi there,

 

Can you check in the Gateway settings that you can successfully connect to all the data sources?

 

There is an option to test connections, in the Power BI Service.

 

I would also suggest making sure that on the server you have got the On-Premise Gateway installed, that it is working and connected. You can do this by opening the On-Premise Gateway and it should display "All good to go"

 

Also if you can ensure that you have downloaded and installed the latest On-Premise Gateway version?

 

And my final is question, is has it successfully refreshed in the past?

VigneshVs's avatar
VigneshVs
Frequent Visitor
9 years ago

Hi Guavaq,

 

1.Yes - The data source connections are successful.

2.Online. You are good to go

3.latest On-Premise Gateway version - yes

4.Refreshed Successfully only in the Power BI Desktop but not in Power BI service.

 

 

Thanks,

Vignesh

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    I am not sure why it is giving you the error then. 

     

    Reason being is if the data source connections are successful on the Gateway settings in the Power BI Service, then that means that it can authenticate and create the communication between your server and the Power BI Service.

     

    The only thing I can think of is if the query is doing something not supported by the On-Premise gateway.

     

    Would it be possible to create a really simple query - "Select top 100 * from table"

     

    Then put that into a Power BI Desktop File, Upload it to the service, connect it to the Gateway and then see if you can refresh?

    In doing so, that will just check to see at it's most basic form that everything is working as it should.

    • VigneshVs's avatar
      VigneshVs
      Frequent Visitor
      9 years ago

      Hi Guavaq,

       

      Unfortunately, one of the dashboard running sucessfully in Power BI service provided the same error yesterday.

       

      So i guess there might be no issues with the scripts being used to refresh in Power BI service.

       

      Regards,

      Vignesh

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        Hi VigneshVs,

         

        In your scenario, which data source did you connect to in your report? Based on my research, there is something wrong in Power BI Service currently. You can see from Power BI support site.

         

        Best Regards,
        Qiuyun Yu

         

         

Related content