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, 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?