cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirman
Advocate I
Advocate I

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
kcantor
Community Champion
Community Champion

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 Super User!




View solution in original post

4 REPLIES 4
nirman
Advocate I
Advocate I

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.!!!

kcantor
Community Champion
Community Champion

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 Super User!




View solution in original post

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.

Anonymous
Not applicable

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.