Replace Error with a Table of Values

[AchalDesai]

Hi All,

I am creating a Currency Exchange Rates Table with a Web.BrowserContents query function (Basically passing the date in the URL to a currency exchange website and fetching the HTML table of exchange rates for that date).

The result of the function is a table with Columns Currency, Units Per EUR, EUR per Unit.

Sometimes however, it so happens that the data for a particular date isn't returned and and ERROR value is shown for that date instead of a table.

What I want to do is replace the ERROR with a static table of the 170 currency pairs with the values for Units Per EUR and EUR Per Unit as 0. 

This is so that when I merge the EchangeRate table with my main query, the error is not transferred and break the query. Instead the Value would be shown as 0.

Hope you guys can help me with this.

[Fowmy]

@AchalDesai 

Use the Try - - - Otherwise error handling option : https://docs.microsoft.com/en-us/power-query/handlingerrors

[AchalDesai]

Hi @Fowmy, The try and otherwise definitely looks helpful.

But can you guide me how I could insert a table of 2 columns and 170 rows in the otherwise part?

[Anonymous]

Hi @AchalDesai ,

You can try to merge or append, please kindly refer to

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Best Regards,

Stephen Tao

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

[Fowmy]

@AchalDesai 

If you could provide a PBIX file with some sample data then it would be helpful for me to try a solution .