Getting Error message while expanding the table after passing URL to invoke custom function

[Ravi123]

Hi Experts,

I have a column which contain URL and i passed it to invoke custom function, when i tried to expand the table i am getting an error message and getting stuck in the row which has error message, i need to handle exception message and continue fetching  the data for all the other rows.

My Custom function :
= (Url as text) as table =>
let
Source = Table.FromColumns({Lines.FromBinary(AzureStorage.BlobContents("" & Url), null, null, 1252)})
in
Source

Table-1Actual Data from URL - 2Error Details -3

[PhilipTreacy]

Hi @Ravi123 

Use try .. otherwise to handle the error

= (Url as text) as table =>
let
Source = try Table.FromColumns({Lines.FromBinary(AzureStorage.BlobContents("" & Url), null, null, 1252)}) otherwise null
in
Source

Further reading if you wish

Handling errors in power query with try otherwise

regards

Phil

[Ravi123]

Hi @PhilipTreacy I tried it but it is not working getting the same error.