cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
adriansuteu Regular Visitor
Regular Visitor

Eliminate permanently a data source and allow refresh in PBI online app without expecting initial ds

Hello.

 

I have conected my report to 2 data sources types initially: a MySQL database and two local files.

Later I have changed the source for the local files to the same files on OneDrive for Business (sharepoint).

I have published the report online.


The issue is that, even if I don't have any local file associated in that report, it still asks me for Gateway connection when I try to refresh it on app.powerbi.com.

 

I have also removed the files completely from the report data source and then re add them on the report directly from sharepoint URL. I have saved the report with a different name, publish it and still it asks for Gateway.

 

This is the Data Source settings now. As you can see there are no local Excel files there.

 

error--gpau.png

Can you please help me? What else do I have to do to make it work?

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
JirkaZ Regular Visitor
Regular Visitor

Re: Eliminate permanently a data source and allow refresh in PBI online app without expecting initia

@adriansuteu Where is the MySQL DB located? It could be asking for a gateway because of that one.

View solution in original post

3 REPLIES 3
JirkaZ Regular Visitor
Regular Visitor

Re: Eliminate permanently a data source and allow refresh in PBI online app without expecting initia

@adriansuteu Where is the MySQL DB located? It could be asking for a gateway because of that one.

View solution in original post

adriansuteu Regular Visitor
Regular Visitor

Re: Eliminate permanently a data source and allow refresh in PBI online app without expecting initia

@JirkaZ  you are right. The SQL db is stored on a server, not on my computer. But it looks like PBI uses my personal gateway to get to that data source. The big disadvantage is that my computer has to be running in order to keep the gateway open and refresh the data online, whereas the server is always running.

 

I have created a new report just with the SQL source, publish it and still it asks for Gateway and only after providing the Gateway I can enter the SQL credentials and connect to the source.

 

Thank you for your answer!

JirkaZ Regular Visitor
Regular Visitor

Re: Eliminate permanently a data source and allow refresh in PBI online app without expecting initia

@adriansuteu It really depends whether the MySQL DB is accessible from the internet or not. If it's a DB on the company's network then a gateway will be needed (either personal or enterprise). You can however install the gateway (I recommend in Enterprise mode) on any computer/server on you company's network so that it doesn't rely on your computer to be always on.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,126)