Data refresh crashes and immediately disappears

Hi,

I haven't really solved it. I manually refreshed all tables and uploaded it to the Power BI Service. It now seems to refresh fine in there, so I'll just try not to touch it until this gets solved.

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.