Forum Discussion
Union Formula mixes columns
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))
here is similar question in the past on this forum
https://community.powerbi.com/t5/Desktop/union-formula-column-section-error/td-p/80004
I have seen that and tried but then i got another error message after a long loading time. Also i had the feeling that with append queries it loads both tables from the datawarehouse. I will try again later and see if it works...
Happy New Year to you as well!
You need to disable the refresh of the query with the "old" data in the query editor (rightclick your mouse while hovered over the query, it is enabled by default):
Sure, interested to see how this get resolved? Will be good for other users as well.
first of all - HAPPY NEW Year everyone!
I tried again the append query function - and it combines now the tables without error. But it is not the solution i wanted as with this append function it retrieves the historic data (1 Million Rows +) and the current data.
Has someone another idea? I don't know why it doesn`t work with the DAX Union Formula.Thanks Imke - i disabled the load (thought that this is only relevant for the refresh all button).
Anyway, unfortunately it doesn`t work, it loads both tables. I tried it with the normal append and with append as a new table.Can`t believe that this is so complicate, that should be a basic function until it is possible to schedule a data refresh...
Are you running the current version of PBI? There has been a bug in this feature that has just been solved with the latest version.
And just in case this is unclear:
If the table with the "old" data shall not be loaded to the datamodel (but instead be only appended to the refreshing query), you have to disable load as well (see screenshot: above the disabling of the refresh).
