Error Handling in PowerQuery

S

Sgligori

New Member
Joined
May 7, 2015
Messages
46
Very new to this Power Query thing. I have a workbook query that has 64,746 errors. What is the easiest way to identify them and correct/delete the errors?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
anvg said:
Hi
It is examples about error handling Returning Error Messages As Well As Results In Power Query – Chris Webb's BI Blog , Handling Data Source Errors In Power Query – Chris Webb's BI Blog for your start.
And read Microsoft Power Query Formula Language Specification about Error Handling http://pqreference.azurewebsites.net/PowerQueryFormulaLanguageSpecificationAugust2015.pdf
Regards,
Click to expand...

Thanks! The first link was very helpful. Looking forward to diving a little more into the second one this week.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Postgres Database in Powerquery on Mac -> MoreQuery
Replies
0
Views
268
Driekes
D
L
  • Question
Error with making hour column from datetime column
Replies
0
Views
155
LambChoptheKid
L
R
  • Question
I have no idea how to find the source of data for a table refresh in Sharepoint
Replies
7
Views
304
RoryA
RoryA
W
  • Solved
How can I force PowerQuery to load the table formatted as "Text", even if some cells contain only numbers?
Replies
7
Views
373
Want2BExcel
W
B
  • Question
How to use the lookup capability in Power Query
Replies
1
Views
107
Matt Allington
M

Forum statistics

Threads
1,215,065
Messages
6,122,944
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top