Power Query - filter - error refreshing

Emilia Daian 21 Reputation points


I have the following code:
= Table.SelectRows(#"Accounts", each ([Year] >=Table.Buffer(Excel.CurrentWoorkbook(){[Name="Year"]}[Content])[Year]{0}) -it will refresh continuously and I need to stop it manually. But,
if I replace >= 2021 - it works. Any clue why is this happening? I don't want to hardcode 2021 instead I want to be read from excel table.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,756 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments