Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
User | Count |
---|---|
48 | |
31 | |
27 | |
27 | |
26 |
User | Count |
---|---|
60 | |
56 | |
36 | |
32 | |
28 |