Forum Discussion
Getting Error message while expanding the table after passing URL to invoke custom function
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
2 Replies
- PhilipTreacy
Super User
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 SourceFurther reading if you wish
Handling errors in power query with try otherwise
regards
Phil
Hi PhilipTreacy I tried it but it is not working getting the same error.
