cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Auomatic Refresh reports successful refresh, but doesn't really refresh the data

I've looked at all the refresh threads I can find on here, but none have a solution to my problem as far as I can tell. I have a desktop application that I have published as a service. It is a report (not a dashboard) on the Power BI web app with its associated dataset. I have set up a scheduled refresh. It claims it is successful and there are no errors, however nothing in my report refreshes. I have tried refresh now with the same results. I have refreshed the data in my desktop application. I didn't publish it as a service again because if I understand correctly, on refresh it should be pulling from that newly imported data. I also changed some visuals in the report and it doesn't update those on refresh either. 

 

The data gateway is set up. The credentials are not needed as an admin gave access to the SQL Server data source.

Capture.JPGCapture2.JPG

 

 

The weird thing is that I have a data gateway set up in the dataset, but when I click the gear icon, it says I don't have any gateways installed and when I got to Settings > Manage Gateways it says the same. Is that what I'm missing?

Capture1.JPG

 

 

The refresh used to work and I don't think I've ever seen gateways installed on the above page, just on the Scheduled Resource > Gateway Connection page. Don't know what to do from here.

1 REPLY 1
Super User IV
Super User IV

Re: Auomatic Refresh reports successful refresh, but doesn't really refresh the data

What could possibly be happening is for the data source you are no longer under the Users Tab

Which means that you no longer have the rights to refresh the dataset, be it manually or via a scheduled refresh.

I would ask the Gateway Admin to confirm that you are a user for this data source.




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors