Power Query - filter - error refreshing

Emilia Daian 21 Reputation points
2022-11-29T16:39:23.387+00:00

Hello,

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
    2022-11-29T16:44:48.12+00:00

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
    https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

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

    0 comments No comments