Forum Discussion
Ravi123
3 years agoFrequent Visitor
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 erro...
PhilipTreacy
3 years agoSuper 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
Source
Further reading if you wish
Handling errors in power query with try otherwise
regards
Phil
- Ravi1233 years agoFrequent Visitor
Hi PhilipTreacy I tried it but it is not working getting the same error.