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

On-premise Data Gateway does not work

Hello, 

 

We are currently on the Power BI PRO (trial account).

 

We managed to configured the On-premise Gateway and the connection to our company MySQL database.

 

Gateway.JPG

 

However, the gateway is not available when we were trying to Schedule Refresh (see image below)

 

ScehduleRefresh.JPG

 

Please advise. Many thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team dimazaid
Power BI Team

Re: On-premise Data Gateway does not work

There might be few reasons why you're not seeing the gateway:
1- The connection information within Power BI desktop doesn’t match the data source. The Server name and database name need to be the same for Power BI to make a match.

2- You have an online scenario in your dataset, it needs to be added as well

3- You're using oAuth with your datasource, which is not supported thru the gateway 



3 REPLIES 3
Power BI Team dimazaid
Power BI Team

Re: On-premise Data Gateway does not work

There might be few reasons why you're not seeing the gateway:
1- The connection information within Power BI desktop doesn’t match the data source. The Server name and database name need to be the same for Power BI to make a match.

2- You have an online scenario in your dataset, it needs to be added as well

3- You're using oAuth with your datasource, which is not supported thru the gateway 



Marlonrb Frequent Visitor
Frequent Visitor

Re: On-premise Data Gateway does not work

and also you need to create a new data source of your data base and include the users as well....

Highlighted
DiegoL Frequent Visitor
Frequent Visitor

Re: On-premise Data Gateway does not work

Do you need to include all the users? Or just the Admin?

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

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.

Users Online
Currently online: 116 members 1,687 guests
Please welcome our newest community members: