Desktop reports errors in a query, but show errors in Power Query is blank.

Hi kleigh ,

Thanks for sharing your experience in resolving query loading errors in Power BI Desktop! I'm sure your efforts will help many more!

Power Query has diagnostics tools that can be used to analyze queries and their performance. You can start diagnostics before loading the data to capture detailed information about the query execution and potentially catch any errors.

If the table shows a column, you can click on the cell where the error occurred to see details of what went wrong.
And for advanced users, running PowerShell scripts can help diagnose problems by accessing the Power BI API and extracting more detailed error messages.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.