Forum Discussion
Power BI - Sharepoint List connection Issues
Are you removing the Default.aspx or whatever is at the end of the url? It should be https://tenantname.domain.com/sites/sitename
Thanks!
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
You have to log in into the Data Source when you connect. You likely were presented a window and you didn't select Microsoft Account on the left side to log in. Consequently, it's using Anonymous access.
To fix, in Power BI Desktop, go to
- File, Options and Settings, Datasource settings
- Select your data connection in the window
- Click Clear Permissions
- Close the dialog
- Click Refresh in the ribbon
- You will be prompted to log into the data source
- Click Microsoft Account on the left side
- Click the Sign In button to enter your credentials
- Select the site address in the dropdown
- Click Ok or whatever to connect
You should now see data.
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
Most Valuable ProfessionalAre you removing the Default.aspx or whatever is at the end of the url? It should be https://tenantname.domain.com/sites/sitename
Thanks!
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
I have got a new error using this format:
- Access forbidden
That's weird because the user actually has access to the Sharepoint.
Does the Power BI require any upgrade on license to connect to Sharepoint List ?
- trebgatte
You have to log in into the Data Source when you connect. You likely were presented a window and you didn't select Microsoft Account on the left side to log in. Consequently, it's using Anonymous access.
To fix, in Power BI Desktop, go to
- File, Options and Settings, Datasource settings
- Select your data connection in the window
- Click Clear Permissions
- Close the dialog
- Click Refresh in the ribbon
- You will be prompted to log into the data source
- Click Microsoft Account on the left side
- Click the Sign In button to enter your credentials
- Select the site address in the dropdown
- Click Ok or whatever to connect
You should now see data.
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
It worked
Thank you