This table is empty when get data from sharepoint

[jeongkim]

Hi

It's weird that I cannot get data but actually there is.

Any reason for this?

Other folder works fine. 

[Anonymous]

Hi, @jeongkim 

The error message "DataFormat.Error: There were more columns in the result than expected" indicates that the data structure in SharePoint may have changed, causing a query mismatch.
Check that there are no changes to the columns in your SharePoint list or library. If you add a new column or remove an existing one, update Power Query to match the current structure. In Power Query Editor, review the steps for the app. Look for any steps that might expect a specific number of columns and adjust accordingly. You may need to modify the Table.ExpandTableColumn step to include or exclude the required columns.
If you have unwanted columns in your SharePoint data, consider removing them from your query to simplify the data import process.
Also check that there are no duplicate column names in your SharePoint data, as this can lead to confusion in your query.
You'll also need to verify that you have the necessary permissions to access all the data in the SharePoint folder. Sometimes, permission issues can lead to incomplete data retrieval.

You can learn more from the following link:

Power BI How to Fix There Were More Columns in the Result Than Expected - Zebra BI

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[christinepayton]

Make sure the account you're connecting in Power BI with has access to both the root of the site and those files. If you're using a different account, or if you only have access to the folder but not the base site, that could explain it (the SP connectors connect to a feed at the base site and then filters down on your criteria). 

[jeongkim]

Hi, 

Thanks, 

is it related to this access?

I'm the owner of the relevent sharepoint folder,,

[jeongkim]

It keeps saying key didn't match but the folder name seems correct..

I copied and pasted. 

[christinepayton]

I think you want to be filtering on the path column, not the name column. I would take that step out, go to the path column, and search for the folder name path to add as a filter there. If you filter on the name = your folder name, you will end up with no Excel files because their name is not the folder name. 🙂

[jeongkim]

Hi, please help.

This is my sharepoint parent level folder.

I can see contents with other folder path

But I cannot see this folder contents below and don't know why,, 

since the path is even copied with above available folder path.

the contents not visible but actually there is. 

[christinepayton]

I think you're using the wrong connector? The SharePoint Files connector is SharePoint.Files, not SharePoint.Contents, and there's no navigation step. You just put in your site URL and then filter the path - e.g. mine looks like this (the path column is off the screen to the right): 

[jeongkim]

I cannot address the URL since files in sharepoint folder keep changing. 

New files come and go every week. 

As I shared above, same sharepoint site - other folder work well as below. 

So need to find what obstacles to get content list. 

[jeongkim]

maybe because of 'shared folder'?

[christinepayton · Accepted solution]

The special character (+) in the folder name might be causing problems-- sharing shouldn't be an issue. 

[jeongkim]

Thank you, it's strange but it worked!

Probably parent folder shouldn't have special character for this.

[jeongkim]

wait,, special character is already in use for other folder(not parent level) and working well..

[jeongkim]

I see, let me try with your assumption. thank you, I will let you know.