Connect excel to azure datalake gen 2 with OAuth
When I am looking at microsoft documentation of excels connections possibilities and it says that my Microsoft 365 Apps for enterprise can connect to Azure Blob Storage and Azure Data Lake Storage
I want to connect to my Datalake Gen 2 in excel, I'll go to the Data tab Get Data > From Azure > From Azure Blob Storage
Here is the question: How do I connect to my Gen 2 datalake with Azure AD / OAuth / username ([email protected]) and password? Storage Account Key Access is disabled on this datalake. That includes Shared key and shared access signature (SAS)
First I want to thank KarthikBhyresh-MT for his input that inspired me to find the right solution.
The Solution
First I found the url to the desired file inside the datalake inside azure portal
I copied the changed the url and changed the word blob to dfs
In excel (office 365) I Get Data > From Web, and put in the altered url. From there I get this image, where I can log into the datalake with OAuth credentials
Then I could load the simple.csv file into excel, work on it and see the transactions in the datalake logs.
- What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
- How to find and replace with regex in excel
- How to change font color for specific line (row) of Textbox
- How to embed a SVG into a Cell using Aspose.Cells
- How to change Font Color of Dates without changing color of other text or background using VBA for Excel
- Run-Time Error 91 (object variable or with block variable not set) on VBA Email code "mailItem.Display" after IF statements
- Deleting duplicate header rows
- mixed date converted from default mm/dd/yy in excel to dd/mm/yy
- Overwrite Excel 2016 worksheet data with data from CSV file
- Laravel validator and excel files error
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Ascii Art using VBA
- How to obtain the full-path names of files read with WorkbookConnections
- How can export all part of columns to pdf file with VBA code?
- Difficult to run
- Allow User Input in Empty Cells, Prevent Editing or Deletion in Occupied Cells
- Export Charts from Excel as images using Python
- Converting 32-bit xll Excel add-in to 64 bit: LNK1561 error
- Changing the Date Format for GROUPED dates in a PIVOT TABLE
- VBA Filter Column Store Unique Values of Another Column
- How do I use checkboxes in an IF-THEN statement in Excel VBA 2010?
- Automatic numbering in Excel with hierarchy
- convert a C# datetime object into Excel date format
- Excel Find and replace using variables
- How to do a row-wise sum in an array formula in Excel?
- Putting Textboxes into array for formatting
- Code inserting and copying to the wrong worksheet
- how to use inequality filter in pivotby formula on aggregated values, not table data
- Excel XML Source pane does not have button to add an XML map