Best Approach for Reporting on Large-Scale Data from Azure Table Storage

[Kedar_Pande]

We are working with a dataset of approximately 200 million records stored in Azure Table Storage, and the volume is expected to grow further. Currently, Power BI's RBA is struggling to handle this large-scale data effectively.

What is the best approach to report on such massive and growing datasets using Power BI? Are there alternative tools or strategies better suited for this scenario?

[Anonymous · Accepted solution]

Hi, @Kedar_Pande 

Thanks for audreygerred's reply. Enable the Fabric F64 trial in Fabric and then try to use the data pipeline to connect to the data stored in Azure and use Fabric Lakehouse/Warehouse to manage your data. See the documentation below for more information.

What is Power BI Premium? - Power BI | Microsoft Learn

Fabric trial capacity - Microsoft Fabric | Microsoft Learn
Move data from Azure SQL DB to Lakehouse via data pipeline - Microsoft Fabric | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[audreygerred]

Which Fabric or Premium Capacity do you have? Is your model star schema? What is the current size of your pbix semantic model? What issues are you having with Role Based Access?

[Kedar_Pande]

@audreygerred 

I have Power BI Pro license. My model is star schema. Power BI is running out of memory when I try to load this 200 million records in Power BI Desktop.