Bug in AzureStorage.Blobs function "We cannot convert the value null to type Number"

[ImkeF]

Hi there,
when expanding binaries that have been retrieved using the AzureStorage.Blobs-function, I am getting weird errors due to the automatically generated code:
There is a function that tries to retrieve the Relative Path of the file that returns an error: "We cannot convert the value null to type Number". The underlying reason for this error message is that the navigation table metadata doesn't contain the record "FileSystemTable.RootPath" as expected by the function.

What makes matters worse is that this error doesn't show up in the dataflow preview window.
So we get a valid result there and wonder why the dataflow refresh fails with that strange error message.
When copying the query over to Excel, the error-message showed up in the preview and allowed debugging.

[Anonymous]

Hi  @ImkeF ,

You may try to handle values explicitly in your Power Query formulanull. You can do this by adding an clause before the non-null text is evaluated.
The formula first checks if the field is . If it is, it returns an empty string. ErrorMessagenullOtherwise, it proceeds with the rest of the evaluation.

If this doesn’t solve your issue, it might be worth considering that the column could be corrupted. In such cases, removing the step/column completely and recreating it has been known to resolve the error.

If i missunderstood your needs,please be free to let me know.

Best regards.
Community Support Team_Caitlyn