Forum Discussion
Data refresh crashes and immediately disappears
Hi,
My data refresh encounters an error, but the window disappears immediately afterwards, so it's impossible to troubleshoot the queries.
Also, refreshing each table individually results in no error for any of the tables, it only crashes when using the refresh button in the ribbon.
8 Replies
To supply some more information:
- Other dashboards using the same data sources run without any issues.
- Older versions (that worked fine in the past) of the dashboard have the same issue
- Clearing all source permissions doesn't work
- Clearing all caches doesn't work
- The dashboard also won't refresh in the Power BI service
Any ideas for how to trouble-shoot or solve this issue?
Anonymous Anonymous I have same issue recently and finally found the root cause by spending lots of time.
My issue was I deleted an uneccessary table and raw data files but still reference M query to make a function (fx) was existing.
Once I deleted it, everything has been fine.
Guessing the function referred to the sample file parameter to load the data, however the file couldn't be found cause an error. And then Power BI should show an error but the frontend table has also already gone that made unable to show a proper error message.
If your issue is different with me, guessing it may related with relationship between active and deleted table/column, because I tested by disabling data refresh to all the tables but still same symptom occurred, thus active table would not be a root cause.
I believe this is a Power BI desktop bug as I didn't experience this issue before, anyways...
May the force be with you.
Can you let us know if you find a solution? I am having the same issue.
I can refresh tables individually but I have quite a few, so it can be very time consuming.
I am experiencing this on several PBIX files. Rolling back to May 2022 update did the trick. Not sure if any of the versions between that and the latest work fine. You can find previous desktop versions here:
