Forum Discussion
Get&Transform / Power Query stuck on load to Data Model
Hi all, I have been working with Power Query / Get&Transform for several years now, and have now run into a problem I have never encountered before. What I am trying to do is load a new query to ...
I've had the same issue a couple times this year using Power Query to import data from the SQL server. The first time, I gave up and went to an older saved version of the file and rebuilt the remaining report.
It looks like clearing the cache fixed the problem. I actually cleared all 3 - Data, Q&A, and Folded Artifacts. I'm relatively new to Power BI, so I'm not familiar with the last two.
Thanks for the help!
In Excel Power Query there is only data cache, thus two questions less. In general yes, keep Excel/Power Query updated and clean caches if you don't use it day-to-day.