Forum Discussion

deepakumar's avatar
deepakumar
New Member
8 years ago

Handling Large Data Sets

Hello! I am pretty new to Power BI and I am looking for advice on best practices. We are attempting to use Power BI to report our largest set of data which is around 60 GB and it's hosted in azure SQ...
rajeev's avatar
rajeev
Frequent Visitor
7 years ago

Hi deepakumar,

 

Imo, since your data is voluminous, you could store the data in SSAS cubes (although this will introduce a new product in your solution i.e. SQL Server).

you could then use PowerBI as a visualization tool.

 

We are working extensively with such a solution where we deal with datasets of millions of rows. Another advantage is that the entire modelling can be centrallized to the server and PowerBI will only contain the visualization layer which will just be a couple of mb in size.

Thanks,

Rajeev.