- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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) failed with the following error:
MySQL: This database function doesn't support the query option 'ReturnSingleDatabase' with value 'true'.
Any ideas of what could be wrong? The credentials are on the database level and I have setup a personal gateway that is running on an always-on server.
Thank you very much in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This saved me a bit of trouble as well, thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Worked like a charm! Thanks!
Any ideas why that goes as an option by default?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 :/.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-16-2025 12:10 AM | |||
05-03-2024 01:29 PM | |||
09-18-2024 04:37 AM | |||
12-19-2024 11:52 PM | |||
08-29-2024 01:45 AM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
9 |