Forum Discussion
Solved
Change Source Problem
I’m trying to change the Data Source for my Power Bi reports to the latest version of MySQL on a new server. I’ve updated MySQL Connector to v9.0.0 and I have entered the new Host, Database name and...
In mine I have to have it UNCHECKED which turns off the need for user approval.
Otherwise the refresh gets interrupted with a similar error to yours.
SamWiseOwl
Super User
Super UserHi PaulSB
Under Options and Settings in the Global options there is a setting for Native Database Queries.
This is on by default and causes an annoying pop up when I execute things like Stored Procedures directly through Power BI. Is yours on or off?
The Native Database Queries is ON
- SamWiseOwl
In mine I have to have it UNCHECKED which turns off the need for user approval.
Otherwise the refresh gets interrupted with a similar error to yours.