Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am not able to connect to an excel in Sharepoint with this:
https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
It won't let me choose between Windows/Organizational account but shows the following message.
How can I change my login settings? They are not visible in data source settings.
@Anonymous,
Firstly, please go to File->Options and Settings->Data Source Settings->Global Permissions, click all the existing sharepoint excel data sources and click "Clear Permission". Then connect to the Excel in use web connector.
Secondly, if you are connecting to SharePoint excel, please use the URL below. If you are using SharePoint online, please use Organizational account authentication, if you are using on-premises SharePoint, please use Windows authentication.
https://your root site url/Shared%20Documents/yourfoldername/excelname.xlsx
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |