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

MY SQL Refresh in Service

Hello I was wondering if anyone could give me a hand on something. I have a MYSQL database which I've connected to in the desktop totally fine but when I publish it I can't refresh. Can I use a personal gateway to do this and if so how do I add it as a datasource? Is the only alternative installing a gateway on a VM and doing it that way?

 

Cheers! 

2 ACCEPTED SOLUTIONS
ibarrau
Super User
Super User

Hi. The answer is yes. You must install a Gateway in any VM that can access the MYSQL from there. The best use of the Gateway would be installing the standard or enterprise version. Then you will need the driver or provider to connect to mysql in the Gateway VM like the one you might have installed to use Power Bi Desktop. It's very important to restart the VM in order to help it take the changes.

Once all that is complete you can add the source in the Power Bi Service to enable the schedule refresh. You can follow this guide in the process. The post is only missing the mysql drive installation
https://blog.ladataweb.com.ar/post/189013278236/powerbigateway-configurar-una-actualización

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

Ailsa-msft
Community Support
Community Support

Hi @gmurdoch_85 

You can add the datasource in Manage Gateways .Choose the gateway you have created and click add data source .

Enter the Server name and Database name for your data source ,and enter the credentials .

Ailsa-msft_0-1622192012092.png

The premise is that you must create a gateway and then add data source in service . And my suggestion is to install the enterprise gateway .

If you dont know how to configure gateway you can refer to the link :

Install an on-premises data gateway | Microsoft Docs

The differences between personal and standard gateways can refer to this link :

Use personal gateways in Power BI - Power BI | Microsoft Docs

I search in forums and find no documents about data source MySQL, but you can refer to the data source SQL Server .

Manage your data source - SQL - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ Ailsa Tao

 

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

View solution in original post

2 REPLIES 2
Ailsa-msft
Community Support
Community Support

Hi @gmurdoch_85 

You can add the datasource in Manage Gateways .Choose the gateway you have created and click add data source .

Enter the Server name and Database name for your data source ,and enter the credentials .

Ailsa-msft_0-1622192012092.png

The premise is that you must create a gateway and then add data source in service . And my suggestion is to install the enterprise gateway .

If you dont know how to configure gateway you can refer to the link :

Install an on-premises data gateway | Microsoft Docs

The differences between personal and standard gateways can refer to this link :

Use personal gateways in Power BI - Power BI | Microsoft Docs

I search in forums and find no documents about data source MySQL, but you can refer to the data source SQL Server .

Manage your data source - SQL - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ Ailsa Tao

 

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

View solution in original post

ibarrau
Super User
Super User

Hi. The answer is yes. You must install a Gateway in any VM that can access the MYSQL from there. The best use of the Gateway would be installing the standard or enterprise version. Then you will need the driver or provider to connect to mysql in the Gateway VM like the one you might have installed to use Power Bi Desktop. It's very important to restart the VM in order to help it take the changes.

Once all that is complete you can add the source in the Power Bi Service to enable the schedule refresh. You can follow this guide in the process. The post is only missing the mysql drive installation
https://blog.ladataweb.com.ar/post/189013278236/powerbigateway-configurar-una-actualización

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!