cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Configuring existing dataset to work with gateway

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper V
Helper V

Re: Configuring existing dataset to work with gateway


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.

View solution in original post

3 REPLIES 3
Highlighted
Helper V
Helper V

Re: Configuring existing dataset to work with gateway


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.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Configuring existing dataset to work with gateway

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Configuring existing dataset to work with gateway

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.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.