Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |