Sharepoint Folder

[admiralman]

I would like to target a folder within a Sharepoint Online library similar to the "connect to folder" functionality that exists on the local client. Can anyone tell me if this is possible? I have seen some articles that state it is possible and they either are inaccurate or the method is a not feasible considering the performance would be horrible. Any help is appreciated.

[IHPQ]

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?

[admiralman]

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.

[Anonymous]

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?  

[dvncan]

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

[oscarmqz]

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

[GilbertQ]

Hi @admiralman

If you open up your SharePoint site in Internet Explorer and then navigate to your Document Libriary and then click on the Ribbon, there will be an option to Open in Windows Explorer.

Once that is done, in the Power BI Query Editor you can then click on Get Data from Excel file and then use the URL and the file name and connect to the file.

Another option is you could possibly do it by clicking on Get Data and then selecting Folder. And then paste in the URL from your Windows Explorer.

[admiralman]

Thanks but I am not looking at targeting a specific file but rather the folder. I want to be able to basically say "for every file in this folder bring in the file, perform the necessary transformations, and merge the data into my dataset so I can report on it". There is this option when targeting files on the local hard drive.

[GilbertQ]

Hi @admiralman

You could possibly create a function for each file and then loop through each file into one dataset?

[admiralman]

Sure...there are a lot of ways to attack this programmatically. I could schedule a power shell to connect and consolidate all files onto one. Does no one know how the Sharepoint folder is supposed to work?