Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ocoder
Helper I
Helper I

New error occurring for no obvious reason. Can't load SharePoint list

After working with a SharePoint list for a number of weeks and having successful data import to Power BI, we made some changes to the list to remove old columns and change the value types on a couple of columns.  Around this time we have also encountered a new error.  Based on where this error occurs in the data import process and the content of the error, it seems like the changes we made should not be the cause.  Still, I provided the information for full disclosure, and to cover for the fact that Microsoft errors are frequently misleading.  We have around 12 lists being imported from the same data source and only one is failing with this error.

 

Expression.Error: The columns parameter must be null, specify the number of columns, specify a list of column names, or specify a table type.
Details:
[List]

 

This error occurs in the M query at the last line shown here:

 

 

let
Source = SharePoint.Tables(DataSource, [Implementation="2.0", ViewMode="All"]),
#"dde03a1b-bc3c-41ee-99b7-ef162bf8cbab" = Source{[Id="dde03a1b-bc3c-41ee-99b7-ef162bf8cbab"]}[Items],

...

 

 

I would try to make changes to SharePoint, but due to the nature of SharePoint, it's hard to roll back test changes like this.

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Ocoder ,

 

This is a bug (#ICM: 240456214) on SharePoint Online Lists V2.0. And the Product Team are working on it. Please be patient and I'll post here once there are any updates.

 

Please check if V1.0 is working for you.

 

 

Best Regards,

Icey

 

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

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @Ocoder ,

 

This is a bug (#ICM: 240456214) on SharePoint Online Lists V2.0. And the Product Team are working on it. Please be patient and I'll post here once there are any updates.

 

Please check if V1.0 is working for you.

 

 

Best Regards,

Icey

 

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

Ocoder
Helper I
Helper I

I have an update to the issue.  I was able to make a copy of the table structure by making a new list from an existing list.  This new list also has the same error.  After deleting all of the columns I could from the new list, it still has the same error.  So now I have a completely empty, bare-bones table that generates this error when trying to add it to Power BI.  I am thinking this is some kind of corruption in SharePoint so I will post a question in their forum.  But any information the experts in this forum can give will be helpful since I detect a high level of finger pointing about to happen.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors