March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
After executing "Close & Apply" in Power Query, I get an error message in Power BI which announces that there are 84 errors in one of my queries.
I then go back to Power Query and finds a Query Error group which contains nothing! Zero rows.
What is happening?
Thank you,
Tamir
Solved! Go to Solution.
Hi Tamir,
Were there errors in the original queries? Can you share the file? Please click the last step in the Query Editor and make sure it's good in this place.
Best Regards,
Dale
Hi Tamir,
I have the same issue in my report. After close and apply its showing 148 errors in one of my query but none in the query editor.
You have any solution for this. How to get rid off query errors group?
Thanks
Hi Tamir,
Were there errors in the original queries? Can you share the file? Please click the last step in the Query Editor and make sure it's good in this place.
Best Regards,
Dale
I cannot send a sample but you gave me the idea how to check and debug my query.
I traced back the steps until I found the culprit 🙂
It still does not answer my question as to why I get errors but the table seems to be empty...but...I don't have errors anymore, so...all is good 🙂
Regards,
Tamir
Hi Tamir,
That's great. The reasons why you get errors vary from case to case. So it's hard to say without file and the environment. It works again anyway.
Best Regards,
Dale
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
86 | |
82 | |
76 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |