Power BI Errors - but no help from Power BI

[comish4lif2]

What's the way to get around Power BI informing you that your queries contained errors - and also - Power BI is unable to "get errors for your queries?"  

[HotChilli]

I'm trying to help you.

I can't change the product so I've given you a workaround.

Post a suggestion in the powerbi issues forum.

[comish4lif2]

The response from a program click on "View Errors" should never be anything other than - here are your errors. 
It shouldn't be - "Unable to get errors" and it also shouldn't be - "you should know to poke around on this other screen."

[HotChilli]

If you open the Power Query editor, you will normally see a Preview of the first 1000 rows of data but you can change this to load the whole data set.

At this point you can click through the query steps to find which one causes an error and investigate that error.

I think there is a theory that most of these generic, unknown errors are caused by datatype mismatches and even then they are caused by text loading into a numeric or date column.

If the data set is fairly small you can use the View menu (column quality checkboxes) to profile the data.

If the dataset is very large, it might be prudent to delete all text columns as a test, see if there are still errors and try and identify the columns