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.

Rémi's avatar
Rémi
Resolver III
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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Worked like a charm! Thanks!

 

Any ideas why that goes as an option by default?

  • Rémi's avatar
    Rémi
    Resolver III
    10 years ago

    Hi,

     

    I don't know why there is this option, I don't know how to use this option.

    I just saw this before with one costumer.

     

    I can't help you more.

  • curth's avatar
    curth
    Power BI Team
    10 years ago

    Are you using the latest version of the personal gateway?

     

    The gateway is on a slightly-different release cycle than the desktop app. We try to order things so that features aren't used by default in the desktop app until they're also available in the gateway. It doesn't always work out :/.