Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power query Sharepoint/ Onedrive Folder connector issue (not showing files shared With me / error)

Hi All,   I am using Power Query to connect to files within multiple OneDrive for business folders (Connecting to each per query) and to combine them to 1 single file. I am Navigating using the 'S...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Please use the lastest version of power bi desktop(2020/5).

Do you connect with the "sharepoint folder" connector?

If you connect to many sharepoint folders which are different sharepoint account, please ensure you provide the correct credential for every source(Edit queries->Data source setting->edit permission).

 

Best Regards

Maggie

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-juanli-msft , Thanks Maggie,

 

Your solution looks like the will work with the error I'm getting for issue 2) I am facing,   however May 2020 update seem to be not available to my region yet.

 

I am using the sharepoint folder connector to get the query started but I change it to SharePoint.Contents on the query to navigate to my files required. (within the OneDrive for business space).

 

Credentials are correct and  the query does connect to the OneDrive account, however my main issue was the files not appearing when go to 'documents' table. it would only show 1 of the folders shared with me at a time.