cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirman Frequent Visitor
Frequent Visitor

Unable to refresh data for reports based on on-premise database (Gateway not working)

Hi,

 

I have created some reports which are referencing to the on-premise SQL Server database via Power BI gateway. I have created a refresh schedule for all these reports.

 

The reports were refreshing correctly till recently, but somehow the reports are now not refreshing now. I tried to investigate for the issue, and as a first step I verified and confirmed Gateway was still up and running. But when I tried to check the refresh schedule of the reports, I found the controls in "Gateway Connection" tab are stuck and not responding. This is happening for all existing reports, as well as I tried creating a new report and still it was showing the same. It doesn't proceed even after waiting for half an hour.

 

Please see the screenshot.

 

 

 

Could you please assist as early as possible?

 

Thanks

 

Nirman

1 ACCEPTED SOLUTION

Accepted Solutions
kcantor Super Contributor
Super Contributor

Re: Unable to refresh data for reports based on on-premise database (Gateway not working)

Uninstall and reinstall the gateway. I had to do this before. Be sure you remove it from the control panel completely before reinstallation.



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
nirman Frequent Visitor
Frequent Visitor

Re: Unable to refresh data for reports based on on-premise database (Gateway not working)

Any idea or help on this issue? This issue makes the product of no use for us honestly. We are unable to refresh (manual as well as scheduled) any report at all.!!!

Anonymous
Not applicable

Re: Unable to refresh data for reports based on on-premise database (Gateway not working)

You could try restarting the server/service where the gateway is installed.

kcantor Super Contributor
Super Contributor

Re: Unable to refresh data for reports based on on-premise database (Gateway not working)

Uninstall and reinstall the gateway. I had to do this before. Be sure you remove it from the control panel completely before reinstallation.



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

nirman Frequent Visitor
Frequent Visitor

Re: Unable to refresh data for reports based on on-premise database (Gateway not working)

Strange! but this worked. Earlier, I upgraded the Power BI gateway which didn't work. Un-installing and re-installing did the trick. Thanks kcantor.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)