Forum Discussion
Issue importing data into Power BI Desktop
I also experience this kind of error while importing a new data to the power bi query.. My power bi project have imported so much data and queries.. and when I add new query, this error happen.. I think that's happen because of the queries in my project is too much.. but I found a tricks to avoid the infinite loading.. here the trick and tips..
1) make a new power bi project
2) import your data, and do some transform and editing you needed in the power bi query
3) open the advanced editor, and copy all of the algorithm, we just need that, yeah you get it!
4) close all of the new power bi project
5) open your power bi project
6) open the power query in the power bi trough transform ada
7) left click in the left side, add new query, blank query
😎 open the advanced editor, and block all text, and paste all the copied algorithm before, and submit it
9) the infinite loading maybe still happen, but just click close and apply
10) your new query is fully loaded!
help this is relevant and help you!