Forum Discussion
Memory allocation error on DAX table UNION 50M+ rows
Trying a quarterly csv file based data refresh and then doing a DAX table union join of old quarters and new quarters - I now get a memory allocation error. Queries to the csv files load correctly. ...
It now appears that no matter what combination of appending queries I try , I get the following error ....
Formula.Firewall: Query 'Bid_Vol_History' (step 'Appended Query1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
According the the query dependency view , the sub queries being appended into the final query are correctly linked to their respective (csv file) data source.
Hi pat_energetics,
If you did any operation in Query statement? How about you reload the data？
Best Regards,
Angelia
Tried that several times with reload / restructure queries / reorder queries - all without success unfortunately....