Solved: Refresh not working

Hepworthnot · ‎08-25-2022

Hi,

I have a power BI report on a sharepoint list.

I have recently deleted some columns in the list and when I try and refresh the Power BI report it fails and I get the message:

TableName

The column 'name of recently deleted column' of the table wasn't found.

I have gone into the data view and deleted the column but that has not resolved the issue.

Can you help please?

Thanks

Phil

AlexanderPrime · ‎08-25-2022

The deleted column may be referenced in the Steps in Power Query. Possibly at an earlier step.

Recommend trying opening Power Query, select the table that you removed the column from, select "Advanced Editor" and see if you can see the removed column name referenced in the code, if it's there, just delete reference to it where possible.

It's likely it's been left over from a filter columns operation.

Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

View solution in original post

Hepworthnot · ‎09-01-2022

That did it thank you.

AlexanderPrime · ‎08-25-2022

The deleted column may be referenced in the Steps in Power Query. Possibly at an earlier step.

Recommend trying opening Power Query, select the table that you removed the column from, select "Advanced Editor" and see if you can see the removed column name referenced in the code, if it's there, just delete reference to it where possible.

It's likely it's been left over from a filter columns operation.

Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!