Forum Discussion

Flori_Abb's avatar
Flori_Abb
Helper I
9 years ago
Solved

Union Formula mixes columns

Hello together   to improve the download speed from our datawarehouse, i want to split up the data in a historic table (Data from 2013 up to 27th of December) and a current data load table (data fr...
Need Help
  • mim's avatar
    mim
    9 years ago

    just a guess, in your dax union formula, maybe try no to reference the table directly, bu use something like

     

    union (summarize(table_current, field1,field2),summarize(table_history,field1,field2))

Flori_Abb's avatar
Flori_Abb
Helper I
9 years ago

Hello together

thanks a lot for you help and the replies. Unfortunately the problem is not solved, it seems not possible to accelerate the data download by having to identical tables (one with historic) and one with current data. 

The DAX Union Formula mixes up some columns - guess that`s a bug and i have no clue how to avoid that. The append query solution is also not working as it always loads both table, even with unchecking "enable load" and "include in report refresh". The only result what i get with unchecking "enabling load" is a mess as it delets all relationships and measures.

So i accept that all as a bug and hope for a solution in the near future. 

 

BR

Florian

mim's avatar
mim
Advocate V
9 years ago

just a guess, in your dax union formula, maybe try no to reference the table directly, bu use something like

 

union (summarize(table_current, field1,field2),summarize(table_history,field1,field2))

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi

       

      ImkeF  and mim 

      Thanks for your hint with Union + Summarize

       

      But now i have the impression that the size of my PBIX files is doubling. Can it be?

      I am doing so:

      Table a 5 Mb

      Table b 6 Mb

      Table resulting of Union + Summarize = 11 Mb

       

      #1 Can that be?

       

      I am quite confused here. I thought that what happens with DAX stays in the memory only.  #2 Is that the case or not??

       

      Best regards. G.

      • ImkeF's avatar
        ImkeF
        Community Champion
        7 years ago

        Yes, that's to be expected.

        Filesize doubles, as data doubles. The data will be stored in the file (on the disk, when closed) ane just loaded to RAM once opened and you work with it.

  • Flori_Abb's avatar
    Flori_Abb
    Helper I
    9 years ago

    unbelievable, it seems that works. Thanks a lot mim! - i will see it finally tomorrow with the new data refresh.

    • Flori_Abb's avatar
      Flori_Abb
      Helper I
      9 years ago

      tested and it works - thanks again!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    UPDATE: 

    Ok, problem solved. It seems that problem was not in DAX, but in AAS beause changes weren't correctly pushed to data model. After updating Data MOdel correctly, everything works fine. 


    Dear  Advocate V, 

     

    I used your solution in my data model stored in Analysis Services and it worked for some time, but now returned table is mixed again and I haven't changed anything in source tables. 

    Funny thing is that it works fine in  Analysis Services, but table is mixed in PowerBi. 

    Do you have any idea what could be  problem?

     

    Regards, 

    Tomasz