Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.