Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I need to import data from an XLSX sheet, stored in an azure blob. It'a a simple file with one table only.
I've seen Excel screenshots showing direct import from Azure blob. But this feature is obviously not implemented within Excel(Mac)
So I tried to use PowerQuery for this the first time (please excuse if I'm asking a too basic question):
I copied the SAS URL for the File from the Azure Storage Explorer to clipboard (set to public access).
I created a new blank query in Excel(Mac)
let
Quelle = ""
in
Quelle
Pasted the URL into the quotation marks, btw Quelle means Source
Saved and returned to Excel, hoping to see my data there what didn't happen. I'm seeing a cell with the source URL, instead the table content.
What am I missing here? Do I need to create a 2nd query for the Excel Sheet? How do I need to do this?
Thanks
Zin
Solved! Go to Solution.
@lbendlin The link you provided explains how to solve the issue with the Power BI Desktop which is (as far as I know) not available for Mac. Also Excel Mac does't provide the needed functionality, but on Win it does.
Meanwhile I was able to solve it and posted the solution as a reply to my Stackoverflow question: https://stackoverflow.com/questions/75584492/import-data-from-azure-blob-storage-in-excel-mac
@lbendlin The link you provided explains how to solve the issue with the Power BI Desktop which is (as far as I know) not available for Mac. Also Excel Mac does't provide the needed functionality, but on Win it does.
Meanwhile I was able to solve it and posted the solution as a reply to my Stackoverflow question: https://stackoverflow.com/questions/75584492/import-data-from-azure-blob-storage-in-excel-mac
You specified a text string as your source. Instead, specify an actual source
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |