Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I'm hoping someone can help solve this problem. I have a report that is built in the desktop app and shared with Power BI service.
The main data source is Excel (one workbook with many worksheets), with some other data coming from Sharepoint lists and forms libraries. I regularly change/add to the data in the excel worksheets and have successful refreshed the data and visuals in the desktop app many many times.
However, today the refresh is not working and I can't figure out why.
The Excel Workbook is stored in my OneDrive
I have made sure that changes to the workbook are saved before I close it (both through autosaving and manually). I have subsequently checked the workbook/worksheets are the changes are still showing
There are no filters on any of the data tables in the Excel workbook
There are no filters on any of the data tables in Power BI query editor
There are no filters on any of the data in the Report view.
All of the visuals in the report that rely on data from that Excel workbook are not updating. Refresh in Power BI works as normal, i.e no error code obtained, but the data is not changing in the Power Query.
Any one got any ideas? I have deadline to meet so helping me sort this is out much appreciated
Thanks
@Hanshans , create a new connect in a new pbix and check if it working.
You can check any known issue at https://community.powerbi.com/t5/Issues/idb-p/Issues
@amitchandak just made a new connection to the Excel workbook in a new Power BI file. Really interesting. A normally connection is made but when I bring in a couple of the tables from the workbook, it is showing the data in Excel prior to the changes I made.
This suggests that the changes have not been saved in Excel but when I go back into the workbook check, all the changes are there.
Why would PBI only be able to connect to the old data and not the new data in the file? I feel like I am missing something but don't know what!
Hi @Hanshans ,
Can I ask you a few questions?
Can you please share a sample or the steps that you tried? Then we can reproduce it. Thanks!
Hi Sujit
No error code. All refreshed as normally but the data is not changing in Power Query.
Thans
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |