Memory Allocation failure on Power Bi desktop app

Hi Anonymous ,
Based on your description, it appears that your issue is that the conversion from DirectQuery to import mode significantly increases the file size, resulting in memory allocation errors when trying to load larger datasets.
You can try these methods to resolve the issue. First, you can use modeling data reduction techniques, including removing unnecessary columns and rows and optimizing column data types. These steps can significantly reduce the memory footprint of Power BI files.
Second, implementing an incremental refresh strategy can help manage the size of your dataset by refreshing only the data that has changed rather than the entire dataset. This is especially effective for large datasets that do not require frequent refreshes of the entire data.
You can check out these documents for more information
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Use storage mode in Power BI Desktop - Power BI | Microsoft Learn
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly