Forum Discussion

Tom12347821's avatar
Tom12347821
Frequent Visitor
2 years ago
Solved

Circular Query

I get the below message when looking at the data model on power bi service. It doesn't show up on desktop version. is there an way to identifiy exactly what it's refering to so I could fix?   Circu...
Need Help
  • gareauk's avatar
    gareauk
    2 years ago

    I encountered the same error and resolved it by adjusting my parameters. Initially, my parameter was designed to either pull in the top 10,000 rows or display the table name.  I did this to reduce the table sizes. I corrected this by changing the parameter to point directly to the source instead of the table name.  After republishing and refreshing, the error disappeared. I hope this helps someone.

lbendlin's avatar
lbendlin
Super User
1 year ago

you can post the link 🙂

  • cdebackere's avatar
    cdebackere
    Resolver I
    1 year ago

    for those interested, this the construdt I now made as a for-like approach to replace the recursive call

    it(s kinda 'pseudo code' as in 'not with the actual webcalls, but the construct is working code

     

    let
      //function generates the xml to get part 'loop' of the answers
      genXML = (loop ) => "<node>" & Text.From( loop) & "</node>",
      //funtion get the answers for the given xml
      getWebresult = (path,xml) => Table.FromRecords({[path=path,xml=xml],[path=1,xml=2]}),

      //get the first partial answer
      result1=getWebresult("APIendpoint",genXML(1)),
      //extract the number of total loops from the first answer
      maxCnt = 11,

      //extract the additional parts of the answer and combine
      results = if maxCnt=1
      then
        result1
      else
        let
          Bron = List.Numbers(2,maxCnt-1),
          stap1 = List.Transform(Bron,each getWebresult("APIendpoint", genXML(_))),
          //convertert stap1
          stap2=Table.Combine(List.InsertRange(stap1,0,{result1}))
        in
          stap2
    in
      results