Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Cannot refresh a MySQL source

Hello,   Using Power BI desktop I have uploaded a report using a MySQL datasource and while everything was working until I set up the refresh and every successive refresh (ondemand and scheduled) f...
Need Help
  • Rémi's avatar
    Rémi
    10 years ago

    Hi,

     

    Can you try to delete this option?

     

    You have to open the query editor, then do a right click on the query on the left, and "Advanced editor".

    On the first line of the new window, I suppose that you can see "ReturnSingleDatabase = true" or something like that, try to delete this and try again.

Florent-Shawns's avatar
Florent-Shawns
Advocate I
10 years ago

Without the option, it works on Excel 2016 but not on Excel 2013. And with the option, it works on Excel 2013 but not on 2016.

 

So it seems like if you both have Excel 2016 and 2013 in your company, you would have to switch all Excel 2013 to 2016 and remove the option.