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,
Power BI desktop provides a "SharePoint Folder" connector that allows us to get all files inside a folder. You could refer to below blog for detailed description:
Combining Excel Files hosted on a SharePoint folder with Power BI
Best 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 GuHi - I'm sure this has already been posted. But in case it hasn't, to target a Sharepoint folder, you need to replace "Sharepoint.Files…" with "Sharepoint.Contents…"
once you do this you can then leverage Sharepoints file hierarchy. Expand the "Shared Documents" table and then everything from there should be intuitive.
hope this helps and apologies again if this is simply a repeat of the above.
Hi, I'm having the following issue: I'm trying to bring all the files from a specific folder in my sharepoint folder. I connect to my sharepoint folder, and I filter the folder path. When I do this from Power BI, I find the Path of that folder, but when I do it from Excel, I can't find it (I of course load all the data on the filter options). Its as if from excel, Power Query is not bringing completely what we have in our sharepoint folder (we have thousands of files). I even copied and pasted the same code from advanced editor.
Hi all, first time poster, long time fan.
I don't have an answer on this (I'm still looking for one myself). What I'm seeing though is an issue around setting the Data Types. When connecting to SharePoint via Power BI, the dates (e.g. date created, accessed and modified) are automatically set as the 'Date' type function.
But in my file and in Matias' screenshot below, the date accessed is null. This causes my Power BI to raise an error stating data type issues. I can't change the data type in the second step, by that point it seems to be too late.
Does that help anyone?
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
