PBI Desktop not fully refreshing from Sharepoint Online

[SPC_123]

1. I have a Sharepoint Online list to which I added a new column.  That new column is not pulling into Power BI Desktop (the refresh is, however, accurately picking up changes to data in the originally imported columns). 

2. Separately, when I created this SPO list from an uploaded Excel file, 3 columns were added that had no data (column 1, column 2, column 3).  They never displayed in Power BI Desktop.   To clean things up in the SPO list, I deleted them from the list.  The problem is now that Power BI Desktop throws errors indicating 'that those columns could not be found'.  I cleared the errors by adding those columns back to SPO.

Any advice?  Many thanks!

[Anonymous · Accepted solution]

Hi,

The error you're receiving indicates that the former column names are hard coded into your query.
You can open the advanced editor and search for the column names to see where.

If you had a "Remove Column" step with those columns you will need to delete or modify it. 

I think best practice is to use "Choose Columns" rather than remove columns, that way only the columns you want are coded into the query.

Hope that helps!

Kim

[SPC_123]

Hi Kim:

Awesome.  I've been able to resolve my issues.

Thank you!