Forum Discussion

WillBatesHydro's avatar
WillBatesHydro
Icon for Helper I rankHelper I
4 years ago
Solved

Multiple remote sources in single query - error handling at source

Hello All,    Hope you are well,    Was wondering if anybody can help resolve my issue in error handling at source level.    A bit of background;   I currently have a pagination function set ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • WillBatesHydro's avatar
    WillBatesHydro
    4 years ago

    Thank you so much for your help - unfortunetly I didnt get chance to try your method before solving for myself. 

     

    Because it was the first time I was trying to load the data to a table in my workbook it was failing completion due to the IDs that hold no order records. To overcome this I just needed to load every row within power query first (Was around 10,000 rows so took a while scrolling to the bottom of the table to load more) then I just removed the errors from the column so when I went to load it to table it worked perfectly! 🙂 

     

    Thanks again, 

     

    Will

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi WillBatesHydro 

 

Did you expand the table column before retrieving order information? Assume you have expanded it and get a column with all order IDs (with null on empty table rows), you can modify the next step similar to below.

 

For example, if the next step is to add a custom column with a custom function which calls order information 

= getOrderInfo([order id])

 

You can use "try" like below

= try getOrderInfo([order id]) otherwise null

 

Or use "if... then.. else..." to deal with null differently

if [order id] = null then null else getOrderInfo([order id])

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.