Forum Discussion

BartVW's avatar
BartVW
Icon for Helper I rankHelper I
2 years ago

Table.Combine in parallel possible?

Hello colleagues   To work around a constraint pulling data from our source system, I am splitting up the data pull into 3 queries that all have their date filter criteria. I then append them all i...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Query1 & Query2 & Query3 ...

 

If the queries are not too large you can also do it DAX UNION instead.

  • BartVW's avatar
    BartVW
    Icon for Helper I rankHelper I
    2 years ago

    I tried this (disabling load and query combine), but in this way it still executes the sub queries one after the other, not in parallel.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Then go for the DAX UNION.  You can hide the tables in Power BI