- Open file in sharepoint
- Open file in excel
- Go to File>Info>Copy Path
- It will look like this
- https://mysite.sharepoint.com/sites/Shared%20Documents/myfile.csv?web=1
- Remove the ?web=1 so the link looks like this
- https://mysite.sharepoint.com/sites/Shared%20Documents/myfile.csv
- In power BI>Get Data>Web>Enter this address>enter your login info
- When you try to update the semantic model in power BI, you'll get another error saying credentials are missing
- Click on the semantic model>three dots>settings
- Data source credentials>Look for your web data sources
- Authentication method = OAuth2
- Privacy Level = Private
- It will prompt for your user credentials
- Data source will now be active
Wednesday, January 8, 2025
Power BI - How to connect to an excel file in your sharepoint or teams
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment