Forum Discussion
Memory allocation error on DAX table UNION 50M+ rows
Hi pat_energetics,
You can disable the option: allow data preview to download in the background (highlighted in yellow backgroud). Please review this article.
Memory usage is related dataresouce, the Power Query steps, computer configuration and so on. Please see the following blogs for references.
Performance Tip for Power BI; Enable Load Sucks Memory Up.
Best Regards,
Angelia
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.
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
