Forum Discussion
Sharepoint Folder
Hi admiralman,
Based on my test, we have to list all available folders, then select those we need from the list. As mentioned in above link:
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.
If we direct to a specific folder in URL (https://microsoft.sharepoint.com/xxxx/xxxx/Shared%20Documents/Power%20BI), it will fail to connect and prompt below error.
Regards,
Yuliana Gu
Hey Ryan Anonymous ,
If its not showing on the sharepoint folder connection have you tried refreshing the preview to see if it appears then?
i must admit it's not a particular issue that has arised for myself as of yet!
alternatively you can use the web data connector? find the URL for the file and use the web connector.
Please ignore the actual text in the image as it was only dummy data. If you use the fulla dress for the file in question once configured you will see in data source settings it will change itself to be a Sharepoint connection rather than a web connection or at least thats what has happened with myself in the past.
Thanks
Al
In my case I reset the connection to sharepoint and then the new folders and files showed. Not obvious thing to need to do though, i guess it caches what it finds on first connection and doesn't refresh for a while.
Hey Neil,
it does cache the first time logon unless within Transform Data/Power Query editor you use Refresh preview within the query you want to refresh