Download files from Azure Data Lake Through Power BI visual

[Nandu2520]

Dear Experts,

I need some help on the below:

we have the pdf files stored as blobs in Azure Data Lake. 

I need to display a table in Power BI where I need to provide links in a column, when we click on these links it should read the blob from Azure Data Lake and download the pdf files.

Is there any option to download the blob from Azure Data Lake directly using URI in the browser or any other option to download. I no need to transform the file in Power BI, just I need to download using a link on Power BI table. Can someone please suggest on how to achieve this.

Thanks

ND

[v-yueyunzh-msft]

Hi, @Nandu2520 

Depending on your issue, you are now connected to ADLS from Power BI and can treat the file links in the Power Report as a column. These file links are links to blob files in the ADLS container, but you need to jump to the browser when you open the link, and the browser will report an error: Authentication lost error.

Based on your current situation, I think there is no problem with the operation you have done in desktop, and it is already the operation that can be supported by Power BI to meet your needs to the greatest extent. You can first log in to the portal.azure.com with your AAD account in the default browser page of Power BI, ensure that your browser already has the corresponding AAD account credentials, and then try to open this hyperlink again in Power BI to try to see if the file can be downloaded successfully.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Nandu2520]

I tried this approach. Even I logged in using AAD in the browser, when I try the file URL, its showing Authentication missing or Public access prohibited for this container error. Is there any way to pass the authentication information while accessing the URL ? Generally in Power BI how to deal these kind of accesses when the other end is secured with Private end points?

[amitchandak]

@Nandu2520 , After you get the pdf, try that can be expanded it as binary

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

https://learn.microsoft.com/en-us/power-query/connectors/azure-blob-storage

[Nandu2520]

I could connect to ADLS from Power BI and I could see the file links in Power Report as a column. These file links are the links pointing to blob files in ADLS Container. I need to download the file from ADLS in the browser when I click on the link from my report. Now, when I click on the link, its opening browser new tab and showing Authentication missing error. 

Is there any possibility to do this? How can we access ADLS blob files from browser ?

Thanks

ND

[PrasannaJ]

Hi @Nandu2520 ,

were you able to solve the problem of downloading blob?

If so, I have a similar solution. Can you help?

Thanks

Cheers

Thanks

Cheers