Forum Discussion

admiralman's avatar
admiralman
Advocate II
9 years ago
Solved

Sharepoint Folder

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 see...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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

admiralman's avatar
admiralman
Advocate II
8 years ago

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.