Forum Discussion
Best Approach for Reporting on Large-Scale Data from Azure Table Storage
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?
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 LearnBest Regards,
Yang
Community Support TeamIf 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
3 Replies
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?
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.
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 LearnBest Regards,
Yang
Community Support TeamIf 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
