Pulling from Sharepoint (not OneLake) - not showing any files

[Anonymous]

I"m having trouble pulling in Sharepoint lists.  I'm using the root directory and nothing is showing.  

Do I have to use the Sharepoint Export to Power BI now?  I can't just link to the Sharepoint list? 

I need to be able to work with Power Query to manipulate the data, not just pull it in straight from the list and use it that way.  I did export it to Power BI, creating a dataset.  But I can't manipulate the dataset in Power Query, so I was hoping to be able to just pull the Sharepoint lists in.  I'm very confused.  Any insight is appreciated.

[Anonymous · Accepted solution]

Ok - for those of us that are brain dead, I was using the wrong connector.  Because, of course I was.  Sharepoint LIST, not Sharepoint FOLDER is what I needed.  I hope you all get a chuckle from this!!!! 🤣