Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Jackson123
Resolver I
Resolver I

large datasets performance problems with 400+colums tables

hello everyone,

now I have a tabular model in powerbi desktop with star schema. several dim_tables and one fact_table. this fact table is very big with 400+columns(most columns are kpis ),one quarter data size is 3 milion rows. we plan load one year data with import mode. then the size of pbix file is more than 1GB. these columns cannot be delete and performance must be quick. DQ is very slow. so , in order to keep good performance , we choose import mode. but I wonder is it ok with model performance ? I mean P2 OR P3 premium capacity can keep good performance for large datasets with 400+columns talbes.

1 ACCEPTED SOLUTION
arvindsingh802
Super User
Super User

Yes even P1 would be able to handel 1GB dataset easily.

Please make sure keeping all your DAX optimised and incremental refresh in place to get best performance


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

1 REPLY 1
arvindsingh802
Super User
Super User

Yes even P1 would be able to handel 1GB dataset easily.

Please make sure keeping all your DAX optimised and incremental refresh in place to get best performance


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors