Documents in Blob Storage

[Anonymous]

Hi All

If a database contains an attachments/object/blob eg a word document/ PDF etc..

Can Power BI report on the data and also show the word document or make it available to the user in any way?

If so how?

[Anonymous]

Thank you @amitchandak , but this is not what I'm after.

Is there a way to identify or list out what is in the blob structure?

[Anonymous]

Thank you @amitchandak 

But the data is in blob in a SQL database, and I want to know if I can understand what documents are there (eg DOC, DOCX, XLS, XLSX, PDF, TXT etc) and 

secondly, can I trigger a hyperlink type to open the document?

[amitchandak]

@Anonymous , There is blog around how to read excel on Azure Blob, Not sure if that can help

https://www.sqlshack.com/how-to-access-data-from-azure-blob-storage-using-power-bi/