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

power BI gateway connection issues

Hi,

 

Bear with me while i try to explain myself/my issue/

 

I am currently using PowerBI to create reports for a website im running. It's come to a point now where the people who the website belongs too would like to be able to view these reports and stats as and when they want. Doesnt sound too bad?

 

A colleauge has installed the Power BI On Premises Data gateway on a server on our network and connected it to the MySQL server that runs the back end.

 

When we test this from the Power BI service, the test comes back succesful and says it can connect to our gateway, however when we try to refresh the data using the gateway it doesnt work. dataconnection-good-to-go.pngdataconnection-not-good-to-go.png

 

I'm not sure why i cannot connect to it, as the service says it can connect to my service but doesnt find it. does any one have any suggestions/advice?

 

Il provide more info if needed. Many Thanks,

 

PhilB

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: power BI gateway connection issues

Hi @PhilB,

On-premises gateway doesn’t work with online data sources currently, thus if you combine on-premises MySQL data source and online data source such as Google Analytics in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review,  please vote it.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gatew...

To work around the issue in your scenario, you can use the personal gateway to schedule refresh for your dataset.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: power BI gateway connection issues

Hi @PhilB,

Does your dataset only contain MySQL data source or several data sources? If the dataset contains only MySQL data source, according to your screenshots, it seems that you only register on-premises gateway but you do not add MySQL data source under the gateway. Please firstly add MySQL data source under the on-premises gateway following the instructions in this similar article. Also please ensure that server and database name completely match between Power BI Desktop and the data source within the on-premises data gateway.

If the dataset contains multiple data source, you would need to add each data source under the gateway.

However, if you still can’t refresh your dataset after performing the above steps, please help to describe more details about your scenario. We need to know that what data sources are contained in your dataset.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PhilB Regular Visitor
Regular Visitor

Re: power BI gateway connection issues

Hi @v-yuezhe-msft

Thanks for the info it was very helpful. We definitely had a working (Connection test successful) data source in place and we had the data source privacy set to Public to help with any potential permissions issues.

Your sentence regarding multiple data sources probably holds the key. We have a Dataset which includes both MySQL Data and Google Analytics Data.

In the "Add Data sources" option on the Gateway there doesn't seem to be an option for analytics. In a mixed location dataset is it required to have all sources in the gateway?

Our main problem is that it looks like everything is set up correctly however when we go to schedule refresh we have no gateways available. If we click "Refresh now" it comes up with a personal gateway error even though we have no personal gateway set up

Moderator v-yuezhe-msft
Moderator

Re: power BI gateway connection issues

Hi @PhilB,

On-premises gateway doesn’t work with online data sources currently, thus if you combine on-premises MySQL data source and online data source such as Google Analytics in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review,  please vote it.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gatew...

To work around the issue in your scenario, you can use the personal gateway to schedule refresh for your dataset.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

PhilB Regular Visitor
Regular Visitor

Re: power BI gateway connection issues

Hi @v-yuezhe-msft,

 

That got it sorted. I can now connect to my data gateway. We had it set up as an enterprise gateway which we have changed to personal and it found it straight away. Both answers very useful.

 

Much appreciated @v-yuezhe-msft

 

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

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