Forum Discussion

AntoineCh's avatar
AntoineCh
Helper I
9 years ago
Solved

Check if query exists

Hi all,   I have a report with 2 elements in PowerQuery : A function returning a table ==> creating queries "Invoked Function", "Invoked Function (2)",  "Invoked Function (3)", etc. A query that...
Need Help
  • ImkeF's avatar
    ImkeF
    9 years ago

    Hi AntoineCh,

    sorry, that was a bit quick. You're right, we need to fetch the tables. So it looks like this:

     

    Table.Combine(List.Transform(List.Select(Record.FieldNames(#shared), each Text.Start(_, 7)="Invoked"), each Record.Field(#shared, _)))
ImkeF's avatar
ImkeF
Community Champion
9 years ago

Hi AntoineCh,

sorry, that was a bit quick. You're right, we need to fetch the tables. So it looks like this:

 

Table.Combine(List.Transform(List.Select(Record.FieldNames(#shared), each Text.Start(_, 7)="Invoked"), each Record.Field(#shared, _)))
AntoineCh's avatar
AntoineCh
Helper I
9 years ago

That works !

 

Thank you very much.

 

Antoine

  • ImkeF's avatar
    ImkeF
    Community Champion
    9 years ago

    Hi AntoineCh,

    I was a bit surprised to hear that this worked, as I thought you were trying to implement a sort of an imcremental load here :-)

     

    At least with the current PBI version, this doesn't work on my PC, as the freezing of the loaded query doesn't seem to work once they are referenced by the Table.Combine query. Pls let me know if that was your intended strategy and - if it works for you - which version you are using.

     

    (You can find the alternative solution here: http://www.thebiccountant.com/2016/11/15/incremental-load-powerbi/)