How can i download an excel file from blob storage?

[Madhavapeddi]

Hi, 

I have a requirement to provide a user to download excel files from blob storage container. Currently I am providing the file link to the user and then download from Azure blob storage but is there anyway that user can download directly(calling download api) instead of having mutliple clicks?

Thanks,

Madhavapeddi

[Madhavapeddi]

I really appreciate your response. Currently I am giving web URL and it's opening in browser. What is download URL link? Sorry didnt follow on this. Could you please elobarate on this? Thanks in advance.

[Anonymous · Accepted solution]

Hi @Madhavapeddi 

Standard Web URL:

• When you provide a standard web URL to a user, it typically points to a webpage or a file hosted on a server.
• If it's a direct link to a file in Azure Blob Storage, clicking the link would generally open the file in the browser if the browser supports its format (e.g., PDFs, images).
• For file types that the browser cannot display (like Excel files), the browser usually prompts the user to download the file.
• The behavior can be inconsistent depending on the browser settings and file types.

Download URL Link:

A "Download URL link" is a specially crafted URL that, when accessed, triggers the automatic download of a file, rather than opening it in the browser. This is particularly useful for files that users need to download rather than view online (like Excel files).

You can refer to the following links that may be helpful to you:
How to get download url of a digital file stored in an Azure storage account - Stack Overflow

Best Regards,

Jayleny

[Madhavapeddi]

Thanks for sharing very useful information. I will try to modify the Azure settings as mentioned in the URL and hope it works. Thank you.

[amitchandak]

@Madhavapeddi , In Power BI you can only give a web URL and the URL will decide the action, Try to use the download URL in the link you are creating