PowerBI Online Services not recognizing On-premises Data Gateway (Personal Mode)

[LOPSAN]

Hi Everyone,

Background: I have the 'On-premises Data Gateway (Personal Mode) downloaded to my work computer. When I publish a Report through PowerBI Desktop, which has Excel and MySQL sources, I am unable to set a 'refresh'. After much troubleshooting, I noticed that the connections I have to my sources is not being "accessed" by the Data Gateway, and instead is automatically being 'accessed' as a 'Cloud Connection'. 

 When I try to manually create a 'New'  Connection, my Data Gateway does not appear in the dropdown field for Gateway Cluster Name. 

Issue: When publishing a Report, the MySQL Connections I have are not being 'accessed' by the On-premises Data Gateway, but are instead being 'accessed' via a Cloud Connection - even though MySQL is running on a Local Server, not Online.

Question: How do I get PBI to recognize MySQL Database as a 'Gateway' Connection and not as a 'Cloud' Connection?

[powerbicrazy123]

@LOPSAN - Were you able to resolve this, I am facing the same issue

[LOPSAN]

Hi @powerbicrazy123 - Unfortunately, no. I was never able to figure this out. I read a couple of articles and post on forums, and I believe this issue was caused by some sort of release Microsoft did for the On-Premise Data Gateway (Personal Mode). 

I ended up pivoting and changing the structure of my "ETL Process", instead of using MySQL and relying on the connection, I connected Salesforce and SAP directly into PowerBI. So, skipping any database management tool - this is not ideal, but it is working for me so far. I essentially manage the tables in PowerQuery on a Semantic Model. In my case, it was a good change, since I "removed" three (3) tools from my "ETL Process". Pentaho (Spoon Data Integration), MySQL, and On-Premise. And simplified it by using PowerBI's ecosystem.

The "impact" to the files I needed to load into PowerBI was that instead of having those files in my local-machine (work laptop), I now have to save everything in OneDrive or Sharepoint... which actually better. 

Hope this helps, best of luck!

[GilbertQ]

Hi @LOPSAN 

It appears that if you want to connect to a masql connection, you would need to instal the standard mode gateway. Here are the differences listed below.

Use a personal gateway in Power BI - Power BI | Microsoft Learn

[LOPSAN]

Hi @GilbertQ - Is this something new that was just updated/changed? Do you know? 

I'm asking because, for the past months (6 months), everything has been working fine. I can confirm that I was able to 'Schedule Refresh' on PBI, for multiple Published Reports, using MySQL as the 'main' connection. And MySQL was showing the 'Gateway Cluster' as Personal Mode.

It wasn't until recently, that I noticed the fact that MySQL Connections were no longer going through the Personal Gateway and were instead being "processed" by Cloud Connection. 

[GilbertQ]

Hi @LOPSAN 

There are changes that happen from time to time, so there could well have been a change made.