Forum Discussion

szelenko's avatar
szelenko
Frequent Visitor
5 years ago
Solved

Recommended Approach for Large Project

Hello friends, im currently working in a large project for an insurance company. Until now i got approx 10 dimensions and 8 fact tables.   Dimensions (some of them) - Date - Customers - Locati...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    5 years ago

    I had a similar project...about 50 tables, 800 measures, 50M records.  I developed the data model in Azure Analysis Services and used that as the source for dozens of individual reports.  Simplified maintenance since measures were all centrally located, performance was adequate (used S0 AAS so it was kind of a weakling, but later upgraded to S1).  That may/may not be an option for you, but if possible it's worth looking at.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi szelenko ,

 

Firstly, Power BI Premium supports uploads of Power BI Desktop (.pbix) files that are up to 10 GB in size. For more details, please kindly refer to: What is Power BI Premium?

 

Secondly, instead of import all data to Power BI, try using DirectQuery mode or a live connection.

Please kindly refer to: Use DirectQuery in Power BI Desktop

DirectQuery, Live Connection or Import Data? Tough Decision!

 

 If you still choose import mode, you can follow the guide in this article to optimize your data model.

 

 

 

Best Regards,

Stephen Tao

 

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