Forum Discussion
Unexpected Error
JUST ran into the same issue - it kept throwing the same error over and over and over... you get it.
Here's what I did -
- get that error dialog box to close out.
- Go into Edit Queries on the Home Tab
- For my case - I deleted the most recent dataset I had added
- Applied the changes
- Then saved the report
- The close completely out of Power BI
- Reopen the Report
Whatever visuals you created with that dataset will be gone - but you'll be able to get in there and redo them.
Not exactly sure what caused it - but my guess is it got in some kind of a loop either while trying to publish data or while refreshing/ calculating. Not entirely sure.
I don't know your exact case but that's what I did for mine without having to lose the ENTIRE report I had just created.
Let me know if this helps! :)
Aha great!
I thought I had lost 2 months of report generation!
In my case, I had created a new column in the database, using modelling, and used that new column to create a visual. Somehow during my 'manipulation' of the visual I managed to get into an infinite loop of errors!
To fix my issue I followed your lead > but instead I copied the new column's DAX to my clipboard > deleted the column > saved as a new file (just to be safe) > re-opened it > and got a 'you fool, you've broken your visual!" type error message but now I was able to delete it!
Everything back to normal and no lost report!
Thankyou Thankyou Thankyou!
For anyone else that finds this thread - I have just had exactly the same error again...
It happened last time whilst working with the new trend lines feature in visuals - and has happened again whilst working with trend lines again!
Is there a trend (pardon the pun)?
