Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SIVA__007
Frequent Visitor

Dataset Refresh

The Data Source Connection and Refresh Option is unavailableMicrosoftTeams-image (1).png when I publish my PBIX file with MySQL connectivity in the Power BI online workspace. Any On-Premise Data Gateway connection is required for the MySQL server.

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. MySQL requires an On Premise Data Gateway. Once installed you need to configure its sources. Do you have any other source besides mysql? if it's onpremise you should configure that too, if it's cloud then we might need to talk about an option in the gateway to let you use hybrid sources (cloud and onpremise at the same time)

After configuring sources you can apply the Gateway Connection setting on the picture.

I hope that helps


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

3 REPLIES 3
ibarrau
Super User
Super User

Hi. MySQL requires an On Premise Data Gateway. Once installed you need to configure its sources. Do you have any other source besides mysql? if it's onpremise you should configure that too, if it's cloud then we might need to talk about an option in the gateway to let you use hybrid sources (cloud and onpremise at the same time)

After configuring sources you can apply the Gateway Connection setting on the picture.

I hope that helps


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

We launch a MySQL Server in an AWS EC2 instance. We Still need an On-Premise Data Gateway.

The Gateway is required for the source. It's not about cloud or onpremise. It's about MySQL requiring the gateway with the driver on the VM. You can install in the same EC2 or another EC2 with visibility of the server with the driver. Restart vm after installing the driver. You can test connection with PowerBi Desktop on that new gateway EC2 if you want. Once you have the gateway running in there, go to Power Bi Service and configure sources for the gateway.

I hope that make sense


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.