Forum Discussion

Brice_LE-LANN's avatar
Brice_LE-LANN
Regular Visitor
6 years ago

Formula.Firewall: Please rebuild this data combination.

Hi all,   I have a table contains some values and I need to do a API call for each item with some conditions. I have trouble with this error: "Formula.Firewall: Query references other queries or ...
Need Help
Tips and Tricks
Brice_LE-LANN's avatar
Brice_LE-LANN
Regular Visitor
6 years ago

camargos88 

 

I am sorry but I don't understand. By what should I replace it?

I need to query this table to get the list of items.

 

Thanks,

Brice

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Brice_LE-LANN ,

 

Do not refer it on the other query, copy the code that queries it from the source.

Try writing the query without dependencies.

 

You can use disable the parallel load tables for performance issues, so it will query just once.

 

 

  • Brice_LE-LANN's avatar
    Brice_LE-LANN
    Regular Visitor
    6 years ago

    camargos88 

    (thanks for the reactivity)

     

    My "otherTable" is exactly extracted from API calls. To be clear, I have:

    - one query which calls an API (get Items), extract some values. (I do some graphs on those value)

    - for some of those items, I want to do another API call to get different data

     

    You advise me to:

    - one query which calls an API (get Items), extract some values. (I do some graphs on those value)

    - create another query which will call the same API, and for each of the value, do another call.

     

    So I do not have depencies (but I call the first API twice).

     

    Is that correct?

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Brice_LE-LANN ,

       

      Can you share your pbix without the key ?

      • Brice_LE-LANN's avatar
        Brice_LE-LANN
        Regular Visitor
        6 years ago

        I am afraid I can't, there is too much data to hide.

        I can share the first query though:

        let
    myKey = "xxx",
    pageLimit = 2,          
    myPageSize= 2,
    order = "-modificationDate",

    FnGetOnePage = (pageId) as record =>
    let 
        HTTPHeader = [Query = [pageSize = Number.ToText(myPageSize), page = Number.ToText(pageId), sort = order], Headers = [#"Ocp-Apim-Subscription-Key" = apimKey ]],
		Source = Json.Document(Web.Contents("https://url.com", HTTPHeader)),
        count = try Source[count] otherwise null,
        values = try Source[values] otherwise null,
        results = [Count=count, Values=values]
    in
        results,

    data = List.Generate(
        () => [pageId=1, result = FnGetOnePage(pageId)],
        each [pageId]<= pageLimit and [result][Values] <> {},
        each [pageId=[pageId]+1, result = [result] & FnGetOnePage(pageId) ]
    ),

    output =  Table.FromRecords(data),
    allValues = Table.ExpandRecordColumn(output, "result", {"Count", "Values"}, {"result.Count", "result.Values"}),
    expendedAllValues = Table.ExpandListColumn(allValues, "result.Values"),
    #"Expanded result.Values" = Table.ExpandRecordColumn(expendedAllValues, "result.Values", {"key", "filteringValue"}, {"key", "filteringValue"})
    
in
    #"Expanded result.Values"