Forum Discussion
Report not refreshing in Power BI service
Let me explain the situation and hopufully someone can help. I have a report, which uses two excel files stored in OneDrive, and which I publish so I can share it to Teams. I have been publishing it for a few weeks with no issues. Yesterday, I made some changes to the format, added some tabs and visuals, and re-published it. It all went ok. Then I realized that two of my filter selections were incorrect. I fixed that, and re-published it. For some reason, those last changes did not go through. I have tried everything I could think of, but the report will not refresh. I tried clearing cache; clearing permissions; using the URL for the OneDrive files; using the refresh button in the Power BI service; I even deleted the report from the Power BI service and re-publish it. Nothing seems to work and I cannot figure out why. There is no error message. The dataset seems to refresh from OneDrive correctly (as per the timestamp). What am I missing? Note that I'm a newbie and I have only been using Power BI for a month. Thanks in advance!
I solved this problem. I'm sharing the solution in case it helps anyone. I was making updates to my report and the filter selection, but I didn't relalize that I also needed to update the bookmarks, which I use to navigate from one tab to another (tabs are hidden in the Power BI service version). Once I updated them, it all worked ok. Thanks to those who tried to help me.
6 Replies
- Greg_Deckler
Community Champion
Anonymous You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". - amitchandak
Super User
Anonymous , have you scheduled refresh on power Bi service. There is ask for credential or gateway details. Check that is correct and giving an issue there.
I don't have any scheduled refresh. The report gets refreshed manually by re-publishing it. I really think this is an issue with the filters. I noticed that when I check in power BI service, the "current" tab looks fine. if I go to another tab and come back, then it no longer looks fine. The filter, which is set from the desktop version, is gone, so it shows all data summarized, instead of just the selected values. I just don't understand why it works when I first land there, but not afterwards. Thanks!
- GilbertQHi there
I would suggest checking this blog post which goes into details on how your OneDrive link could be broken and gives you a way to check?
https://powerbi.tips/2019/09/updating-pbix-files-in-sharepoint-dos-donts/ - Nimai123
Post Patron
Hello Anonymous
You can try doing this hope it helps!
- Update the Gateway.
- Re-configure the Gateway. (Check the mappings)
- Raise a support ticket which is free if you are a PRO user, they will help you to understand the source of error so that we can work in the right direction.
- Use the right mode Gateway - Standard Mode.
If you like my solution give it a Kudos!
And if it solves your problem accept it as a solution.
Regards,
I solved this problem. I'm sharing the solution in case it helps anyone. I was making updates to my report and the filter selection, but I didn't relalize that I also needed to update the bookmarks, which I use to navigate from one tab to another (tabs are hidden in the Power BI service version). Once I updated them, it all worked ok. Thanks to those who tried to help me.
