is it a direct query or import

Hi stanteitelbaum,

Thanks for the follow up. From the screenshots you have shared, it is now clear that your Power BI file is using a Live connection to a SQL Server Analysis Services (SSAS) model.

• In Live mode, you can create measures but not calculated columns that’s expected behaviour.
• The “Storage mode” does not appear in the Properties pane because it's only available for Import or Direct Query models.
• When you go to Data Source Settings and see the SSAS server prompt, that confirms it’s not an Import mode.

So yes, your PBIX file is connected live, and not importing data, which is why your refreshes work fine and you are not running into memory issues.

If your coworker is trying to import the full model into Power BI, that could cause memory exceptions, especially with large datasets (e.g., 66M rows). Instead, she could try:

• Using a Live connection (same as yours),
• Ensuring she's on the 64-bit Power BI version,
• Or reducing data size during import via filters.

Please refer to the below mentioned link:
Connect to Analysis Services data in Power BI Desktop - Power BI | Microsoft Learn

Hope this helps. If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.