Power Query Using Sharepoint Folder

Question

Hello,

I am attempting to run a power query using a sharepoint folder.  I am not able to drill down to a specific folder, so the I am pulling all the data from the sharepoint site.  The data that comes in is incomplete, and the folder I need is missing.  Any suggestions as to how I can get all of the data to come through?

Thanks,

Danielle

Answer 1

Hi Danielle,

Did you need further help? Do you have any updates?

Regards,

Qing

Answer 2

Hello,

Here is a screenshot of the error message I receive:

I receive this message after entering this url:

When I attempt to shorten the URL by removing the Accounting sub folder, it does not pull all of the files I need.

I am using Office 365 ProPlus.  

Thanks,

Danielle

Answer 3

Hi Danielle,

Thanks for your updates.

I have tested this on our side, I didn’t meet the issue.

I can get the following data as below:

To narrow down the issue, I suggest you try another site to check the result.

If the issue still exists, I want to collect the following information for further analysis:

1.       The screenshot of error message.

2.       The version of Office. (Click File>select Account)

Regards,

Qing

Answer 4

Hi Qing,

I ran the Power Query using the Get & Transform Data on the ribbon.  I chose get data, from file, from a SharePoint folder.  When I entered the URL, if I tried to drill down, I received this message:

Unable to Connect:

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: 

OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)

OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)

OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"

I was able to enter the root URL, and it pulled only the folders starting at the letter 'G'.  All of the permissions are the same on all of the folders.

This my first time using the query with SharePoint.

Thanks,

Danielle

Answer 5

Hi Danielle,

Thanks for posting the question on our forum.

According to your description, I need to confirm if you store the power query on SharePoint folder, but you can’t access to the subfolder.

If so, to narrow down the issue, I want to collect the following information for further analysis:

1. How did you run power query via SharePoint folder?
2. Check if all folders meet the issue.
3. Can you use the feature normally before? Do you have any updates?

Regards,

Qing