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

ImkeF's avatar
ImkeF
Community Champion
9 years ago

Hi Florian,

I'm awfully sorry, but you're right: The bug is still there.

I tested it & must have done sth wrong (or it doesn't work consistently, which I doubt).

Don't include in Report Refresh will be ignored once you reference that table from other queries in the query editor or (what I didn't test before) from a DAX-table-creation-operation.

 

Pls leave your support for the bug-solution on the bug-report here - this should really be solved: http://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-Report-Refresh-quot-works/m-p/101993/highlight/false#M46007

 

Thx!