Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey all - major issues here that I can't seem to figure out. Hoping it's an easy fix.
I have an excel spreadsheet I store on OneDrive for Business. I created a PoewrBi dashboard to show some of the cells. Works great. Except it won't refresh. The reports shows the excel sheet and the correct information, but the dashboard won't update. Even if I click on refresh now, it won't refresh. The dashboard shows old data, as if it's not reading from the current sheet.
Please help!
Is the date set updating? Are you seeing any errors when you go into the Schedule Refresh area? Generally if there is a problem with the refresh some sort of error will show up there. Did you upload it from OneDrive or "Connect"?
Thanks for the response. It's quite odd. No errors. The report is linked to OneDrive for Business. No errors there when I view the report.
The issue seems to be the 2 dashboard tiles I made from the report. I view the report and the report shows the correct number based on the formula (it's a fomula that calculates the value based on the day, so it should change daily, and it does in the report view). However, when I go to dashboard that's to show that cell, it shows the old data; even if I click the refresh dashboard tiles manually.
I'm at a complete loss here.
Thank you!
I've attached an image of my sidebar for help -
So, did you apply any filters to your report prior to pinning the tile to the dashboard. Once you pin a dashboard tile, it retains the filter context of the visual/report at the time of pinning the tile. This may seem odd, but is intended to allow you to enhance/change the report without affecting the tile. However, if you had filtered the tile/report by the latest date in the data let's say and then pinned the tile and then update the data, the report and dashboard would behave exactly as you describe.
Not saying that is what is going on, but this does tend to cause confusion for people.
I applied no filters. I view the report, selected the cells, and chose to "pin it". That's all I did.
What is interesting is that it seems that perhaps the tile refresh is based on the file save date? It seems that if I go in to the Excel file on One Drive - and save it - and then refresh - that it works. It's almost as if there is some sort of logic that says --- if file.save.date is unchanged then don't refresh.... but if file.save.date is changed, then it will refresh. This makes no sense to me. Given I have formulas that update based on dates, this makes it difficult (e.g. =COUNTIF(B3:B1000,TODAY()-1) ) - so even though the file may not be new or saved, the value of the cell will change based on the day.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.