Forum Discussion
Why Does this Query Produce a Cyclic Reference
I am trying to filter data Power BI Desktop brings in using Power Query, but the query I've made causes a cyclic reference and am unsure why. Here is the Power Query M text: let
Source = Common...
I assume that the "Responses" table is another table/query already in Power Query. If so, try this instead:
All_Walkies = Table.AddColumn(Walkies, "ResponsesId", each Table.FindText(responses, [responsesid]))
in
All_Walkies
Table.FindText will return the whole row in the other table if it contains your text in any field. It's like a fuzzy Vlookup. Sometimes the syntax can trip me up, so play around with it.
--Nate