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 ProfessionalYou are either putting in the URL for the list instead of the site URL OR you didn't select Microsoft Account and sign in with your O365 credentials when prompted to log into the site.
Thanks!
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/
Hi Treb,
Thanks for your reply.
I have tried putting both URL for the list and site, but I have got the error the same way.
When I set the URL for the list, an error 404 is displayed;
When I set the URL for the site, an error is displayed telling me that the URL is not valid.
Also, I have checked that I am signed on both Power BI and Sharepoint accounts.
If you have any other suggestion, that would be great.
Thank you !
- trebgatte
Is this SharePoint Online?
--Treb
Yes, it is.
- trebgatte
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/