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 to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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
278
Driekes
D
L
  • Question
Error with making hour column from datetime column
Replies
0
Views
163
LambChoptheKid
L
R
  • Question
I have no idea how to find the source of data for a table refresh in Sharepoint
Replies
7
Views
313
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
386
Want2BExcel
W
B
  • Question
How to use the lookup capability in Power Query
Replies
1
Views
119
Matt Allington
M

Forum statistics

Threads
1,215,227
Messages
6,123,745
Members
449,116
Latest member
alexlomt

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