Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I managed to get the freshly installed on-premises data gateway up and running, everythings ok in the app.powerbi service. I can make a new report, get data from our mysql database, make a few visualizations and make the scheduled refresh work.
However I haven't found a way to get this all work on an existing report usign the same mysql database and same tables. All I get is:
"You don't have any gateway installed or configured for the data sources in this dataset. Please install a new data gateway, or configure the data source for an existing data gateway. "
I've Googled my butt off to find a way to get the old reports to use the gateway but I just haven't found any solutions. Do I have to do all the reports from scratch or is there an alternative?
Solved! Go to Solution.
Make sure the Gateway is configured to use the MySQL database and the connection is active.
Delete the old (existing) datasource from app.powerbi and upload the file again. Try setting up the refresh now.
@MHongisto,
Does the existing dataset only contain MySQL data source? If so, make sure that the connection string(server name, database name) you use in Power BI Desktop match that you use in gateway.
However, if your dataset contains multiple data sources, please ensure that you add all the data sources within gateway.
Regards,
Lydia
Make sure the Gateway is configured to use the MySQL database and the connection is active.
Delete the old (existing) datasource from app.powerbi and upload the file again. Try setting up the refresh now.