Forum Discussion

rheitrich's avatar
rheitrich
Frequent Visitor
6 years ago
Solved

SharePoint list based report will not refresh data.

  Hello.  I am new to the community and somewhat new to POWER BI. I have read anything I could find on similar issues but I cannot seem to figure out the solution.    I have created a simpl...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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"

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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"

 

rheitrich's avatar
rheitrich
Frequent Visitor
6 years ago

Thanks so much for your help!!