Forum Discussion

pat_energetics's avatar
pat_energetics
Icon for Advocate II rankAdvocate II
9 years ago

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. ...
Need Help
pat_energetics's avatar
pat_energetics
Icon for Advocate II rankAdvocate II
9 years ago

Unfortunately this tip did not resolve the issue.

 

Now trying a different order and size of query to see if the issue is in the way in which queries are appended into one before loading.

 

Any other ideas appreiciated.

pat_energetics's avatar
pat_energetics
Icon for Advocate II rankAdvocate II
9 years ago

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.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi pat_energetics,

    If you did any operation in Query statement? How about you reload the data？

    Best Regards,
    Angelia

    • pat_energetics's avatar
      pat_energetics
      Icon for Advocate II rankAdvocate II
      9 years ago

      Tried that several times with reload / restructure queries / reorder queries - all without success unfortunately....