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

Gateway not found when MySQL server changed

I have a problem related to changing the location of my server.

 

On my deskop I connected to an MySQL server, built my report, published to powerbi.com and successfully refreshed using an on premise gateway.  The server name was something life xxxxxxxx.rds.amazonaws.com.

 

A DNS was configured to point to the server and the on premise gateway was updated.

 

I then opened my pbix file on my desktop, changed the location of my MySQL server from xxxxxxxx.rds.amazonaws.com to the new DNS name, I could connect and refresh locally. Then I published to powerbi.com but now my dataset can not see the gateway.

 

I created a new report with the DNS and published to powerbi.com and the gateway was found, so the gateway works for a new report but not an existing report with the location changed.

1 ACCEPTED SOLUTION

Accepted Solutions
Spower_Man Frequent Visitor
Frequent Visitor

Re: Gateway not found when MySQL server changed

I resolved this, the problem was that I had multiple data sources, one being MySQL and the other being from SharePoint. On the gateway the option for "Allow user's cloud data sources to refresh through this gateway cluster" needed to be ticked. See here for further details https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

 

14-08-2019 8-38-57 AM.jpg

1 REPLY 1
Spower_Man Frequent Visitor
Frequent Visitor

Re: Gateway not found when MySQL server changed

I resolved this, the problem was that I had multiple data sources, one being MySQL and the other being from SharePoint. On the gateway the option for "Allow user's cloud data sources to refresh through this gateway cluster" needed to be ticked. See here for further details https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

 

14-08-2019 8-38-57 AM.jpg

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 382 members 3,889 guests
Please welcome our newest community members: