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 - 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
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
Ok...need to revive this thread. I have managed to follow the steps in this post and using the desktop application can connect just fine and transform my data. However, when I deploy it to the powerbi service and attempt to refresh the dataset I get the following error. I have seen this error before on my desktop after an upgrade but a) am not seeing it now and b) only see it in the service. Any ideas?
Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987. Table: Query2.
