cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mfoley10
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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.