Load an Excel stored as a blob file from Power BI Desktop

Question

Hi,

I have a report that loads an Excel from local in Power BI Desktop. But I would like to upload that Excel to our Azure Blob Storage to make it available to the team aswell.

However, when I change the source, it seems that I cannot load an excel from blob, just CSV files (with Excel format Power BI merges all sheets and data is nosense).

Have you ever try this before and solve the issue?

Thanks!!!
Paula.

Answer 1

Hello @Álvarez Álvarez, Paula ,
Just to add to what @shiva patpi called out above . if you are trying to add five worksheets what worked for me if I coped the query and pasted the same and pointed the new query to a new worksheet .
The below animation will make it clear .

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 2

Hello @Álvarez Álvarez, Paula ,
Apologies for late reply !
I just tried testing using test.xlsx with 2 sheets and I just followed the steps mentioned here : https://www.sqlshack.com/how-to-access-data-from-azure-blob-storage-using-power-bi/

I was able to see all the required tables (i.e. Sheets) , if you are not able to see - can you provide sample sheets of your data ?

Here are the screen shots of my local testing:

Kindly let us know if the above steps helps you out.

Answer 3

Hello @Álvarez Álvarez, Paula ,
Thanks for your query. I just followed the steps mentioned in the document
https://www.sqlshack.com/how-to-access-data-from-azure-blob-storage-using-power-bi/

I was able to load .csv file from my azure blob storage account to PowerBI desktop with all the required data.
From that document , make sure to see the section "Format the output of the Power Query Editor"

Let me know if that helps out !

Please make sure to "Upvote & Accept the Answer".