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
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
Hi there,
I managed to retrieves for certain folders. Using the same query, I just changed the url. But, the same query (with modified url) is either not returning any return from other folders or returning incomplete list. Why is that so?
I'm having the same issue, the list is incomplete, the actual folder that I need is missing :( Where you able to fix this? Regards
This could be because it shows an inital preview of the file/folder. If you select load everything should be pulled, or transform it will pull all the required data.
I noticed this pulling tables from SAP that are 1mil lines long and only seeing first couple hundered until loading or pulling the data into the transformation staging area.hope it helps,
Duncan
