Configuring existing dataset to work with gateway

[MHongisto]

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?

[Anonymous]

@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

[prihana · Accepted 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]

Thanks, this worked with getting the dataset to use the gateway. I tried just uploading the dataset from desktop, but I didn’t delete the old one before uploading.