Forum Discussion

Hepworthnot's avatar
Hepworthnot
Frequent Visitor
4 years ago
Solved

Refresh not working

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:   TableNam...
Need Help
  • AlexanderPrime's avatar
    AlexanderPrime
    4 years ago

    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. 

AlexanderPrime's avatar
AlexanderPrime
Solution Supplier
4 years ago

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.