Forum Discussion
Get data - SharePoint online list - From a Subsite
Hi， mrichardsPGS
I can't reproduce your problem . It works well in my PowerBi.
It's important to configure that your account have access to the SharePoint subsite not just home page first.
(Configure by taking a try to access the resources of sharepoint subsite directly in website )
(If not ,share the website or edit site permissions in " sharepoint site setting" )
And then you can take a try to clear your permissions and re-sign in your account as belows.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Most Valuable ProfessionalI suspect you selected Anonymous access when you connected to the list. Check out the video in this blog post to ensure you did all the steps. https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/
Hope this helps!
--Treb, Power BI MVP
Hi trebgate,
thanks for the link.
I have actually already logged in as you describe in the video. And it seems to be sucessful as I can access lists from a site with address, sharepoint.com/sites/QHSE, the issue is I get the error when I try to access a subsite of QHSE, sharepoint.com/sites/QHSE/lessons.
there was a step in the video where you pick out where you want to login after entering the microsoft account details and I cannot remember what I entered here. Would you need to slect the site or subsite you want to connect to do you think?
Anyway I cannot seem to get back to this option window anymore. I have logged out of PBI but it no longer pops up the window to ask me to choose between Anonymous/Windows/Microsft. Any idea how to force this window to pop back up so I can confirm the details I entered?
Cheers, Marc