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 ...
Hello,
Let's try this steps and hopefully, it works
1. Click on Get Data dropdown
2. Select Query Options
3. In the Data Load pane of the Query Options dialogue box, Clear Catch and Restore Defaults
4. Click OK.
Then try to load the data to see how things goes..
I have attached a caption of my Power Query
Looking forward to hear from you
Let's try this steps and hopefully, it works
1. Click on Get Data dropdown
2. Select Query Options
3. In the Data Load pane of the Query Options dialogue box, Clear Catch and Restore Defaults
4. Click OK.
Then try to load the data to see how things goes..
I have attached a caption of my Power Query
Looking forward to hear from you
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.
