Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.