Forum Discussion
SharePoint list based report will not refresh data.
Your row called "Removed Other Columns" is still refering to the deleted step. Most power query lines refer to a previous row. If you deleted the row in the Applied Steps, it makes the coding updates for you.
I'd expect this to work
let Source = SharePoint.Tables("SiteURL", [ApiVersion = 15]), #"SourceID" = Source{[Id="SourceID"]}[Items], #"Removed Other Columns" = Table.SelectColumns(#"SourceID",{"Title", "ShortName"}) in #"Removed Other Columns"
Give this a try. Go into your Power Query code and remove the "ID Rename" step. Instead, select the columns you want and choose the "Remove other columns" option. This will let you optimise your model and hopefully get around the issue.
Thanks Ross73312
I tried following your instructions. I tried removing the "ID rename" step but it generated an error. I was not sure what to do with the "in" clause as it only had the #Renamed Columns". I then did the suggested column removal step first, and then removed the "ID Rename" step but it still generates an error.
The query now looks like this.
let
Source = SharePoint.Tables("SiteURL", [ApiVersion = 15]),
#"SourceID" = Source{[Id="SourceID"]}[Items],
#"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"Title", "ShortName"})
in
#"Removed Other Columns"The error is:
Expression.Error: The name 'Renamed Columns' wasn't recognized. Make sure it's spelled correctly.
Thanks again
Your row called "Removed Other Columns" is still refering to the deleted step. Most power query lines refer to a previous row. If you deleted the row in the Applied Steps, it makes the coding updates for you.
I'd expect this to work
let Source = SharePoint.Tables("SiteURL", [ApiVersion = 15]), #"SourceID" = Source{[Id="SourceID"]}[Items], #"Removed Other Columns" = Table.SelectColumns(#"SourceID",{"Title", "ShortName"}) in #"Removed Other Columns"Thanks so much for your help!!
