cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver II
Resolver II

Huge model Size best practice

Hi guys,

I have quiet a large data source.

Data is PnL data in a banking environment.

I have tried to aggregate from source as much as possible, but it still about 30mil records a month. Over 4 years.

 

What would the best practise be when wanting to create PBI reports and dashboards?

Connect live to an OLAP/TABULAR model. (does PBI not load the entire TAB model into memory?)

load from the data warehouse?

 

my concern is the size affecting perforance.

 

can I partitian the data?

 

thanks    guys

Ian

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Huge model Size best practice

Hi @IanCockcroft ,

Firstly, Power BI Premium supports uploads of Power BI Desktop (.pbix) files that are up to 10 GB in size. For more details, please review this article.

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

Thirdly, if you don't have Power BI premium license, it is better for you to use DirectQuery or Connect Live mode to connect to the data source as 1GB limitation doesn't apply to directquery datasets.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Huge model Size best practice

Hi @IanCockcroft ,

Firstly, Power BI Premium supports uploads of Power BI Desktop (.pbix) files that are up to 10 GB in size. For more details, please review this article.

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

Thirdly, if you don't have Power BI premium license, it is better for you to use DirectQuery or Connect Live mode to connect to the data source as 1GB limitation doesn't apply to directquery datasets.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Resolver II
Resolver II

Re: Huge model Size best practice

Thanks Daniel,

I did find those articles yesterday.

cheers

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors