Data source error: Expression. Error: The column wasn't found

[NBHANE]

Hello,

I have a sharepoint list. This list feeds into Power BI. I spent a consirerbale amount of time building the reports linked to it.

All was working fine - untl today. When I got the below error:

Data source error: Expression.Error: The column 'Name facilitating the event' of the table wasn't found.. Name facilitating the event. 

I have not edited, renamed or moved this column - but can't figure out how to fix it....

I just need to know what to do to fix the isse, everything looks correct, but tried to refresh and just keeps failing 

[NBHANE]

Thank you, but was really just hoping to fix the exisiting issue

[lbendlin]

How many columns are you pulling from the list? How many of these are lookup columns?

[NBHANE]

16 columns. 6 are lookup. 

[lbendlin]

There is a limit on lookup columns. You can only have 6. Anything above that will be randomly dropped.

[NBHANE]

Sorry just double checked it's only 5 lookup colums that pull through to the first part of the list. 

[lbendlin]

Create a view on the SharePoint list that only includes the columns you really really need. Then use the SharePoint List connector v2 and use that view.