cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Failed Refresh

Hi all,

 

I am experiencing an issue with a dataset refresh.

On Power BI Desktop, I connected to my SQL server, created the first dataset, reports and published it to Power BI.

A gateway installed on the remote server ensures communications between POwer BI and the SQL server take place. Everything works fine and the dataset is refresh automatically, every day, as scheduled.

 

I created a second dataset, from the same SQL server, from the same SQL database, using the same login credentials. The only difference is that this new datase will also connect to xe.com to download the currency rates table. I added this webpage as a data source in the gateway settings, in Power BI service.

 

When I try and refresh this second dataset manually, it returns the error in the screen shot below. 

It is also asking me to install the personal gateway.

I cannot understand why given that the first dataset refresh works and the gateway is reported to be working.

 

Do I need to go back to the actuall Power BI Gateway application and change settings? Perhaps, the remote server ,where the gateway application is installed, does not allow communications to that web page. Whereas the SQL server is on the same network.

Could that be the reason? 

 

Snag_4b98a36.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III
Resolver III

Re: Failed Refresh

You should be able to combine on-premises and cloud data sources through the gateway. See this article for a detailed explanation: https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud.

View solution in original post

2 REPLIES 2
Highlighted
Resolver III
Resolver III

Re: Failed Refresh

You should be able to combine on-premises and cloud data sources through the gateway. See this article for a detailed explanation: https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud.

View solution in original post

Highlighted
Helper V
Helper V

Re: Failed Refresh

@Michiel that was the solution, thank you.

 

I had to install the gateway on my PC, in personal mode. Am I obliged to keep it running at all times now?

That is exactly what I am trying to keep away from.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors