Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am trying to read an excel file stored in Sharepoint using Power BI python script. But getting the error: 401.
r = requests.get(url, auth=HttpNtlmAuth(user, pwd), headers=headers)
print(r.status_code)
When I login into Sharepoint I go through 2-step authentication process. First is Username & pwd and then approving a Login request using Microsoft Autehnticator app on my mobile.
How to access Sharepoint data in such a scenario?
I also have the same questions, how to read sharepoint data into Power BI using Python script?? I tried sharepy · PyPI i also tried Office 365 & Microsoft Graph Library for Python but I got an error that won't let me even connect. Is there an easy way to stablish the connection from power bI? I tried the sync of the file to my pc, but that will only work for me and I need that people from my organization can refresh it from the workspace. It means that each of us have to use our own credentials.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |