Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I have a folder within sharepoint I want to access. (It has two excel documents inside that I want to seemlessly connect with power bi ) However when I go to get data--> sharepoint folder--> and paste the sire url I get the following messege.
Any help would be greatly appreciated.
Solved! Go to Solution.
basically as described here:
https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/m-p/240225/highlight/true#M106688
@v-yulgu-msft wrote:
Now that we’re in, we’ll be able to see all of the files from all of the folders that we have access to in that specific site. This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
Proud to be a Datanaut!
are you putting the whole folder path in the connection?
in general you connect to specific to a specific SharePoint site first, and then filter for a specific folder
e.g.
company.sharepoint.com/sites/sitename/
and then filter for a specific folder in the path column
I can connect to the share point site, but what do you mean by saying to "filter for a specific folder in the path column"
Thanks
basically as described here:
https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/m-p/240225/highlight/true#M106688
@v-yulgu-msft wrote:
Now that we’re in, we’ll be able to see all of the files from all of the folders that we have access to in that specific site. This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.