cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Dataset and Total Data

Hi all, I went online an searched for Data Limits of Power BI pro and Power BI Premim but I'm getting confused.

Here's the problem that I have:

In our database there are 10 tables that are 5 gb each. All the tables have same columns/attributes. They are just storing multiple scenarios for a business process.

I saw that Power BI pro user can only import 1gb  per dataset to Power BI. (10gb in total)
Is the dataset referring to 1 table that can be imported?

Let's consider only 1 table that is 5 gb for now. Can following be a solution?
For example, if in the database I run a query to divide 5 gb table such that the tables are less than 1 gb each (say 6 tables) and I import those 6 tables one by one. I can do two things after this:

1. create an index table and link all 6 table in one Data Model or 
2. Append the 6 tables into one table.

If I do any of the above, will I be able build visualization and publish the report in Power BI Services given that the limit is 10 gb in total?

If the way I'm thinking to deal with this doesn't work, what will be the ideal solution to deal with this problem?






 

 

 

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Hi @Anonymous ,

 

Specifically, Power BI leverages the xVelocity compression engine and works on a columnstore in-memory technology. In-memory columnstore technology compresses data and stores it in a compressed format.

When using import mode, the size of the model is limited. Your power bi (or file) model cannot exceed 1 GB. Typically, the maximum account capacity is 10 GB, but the maximum capacity per file must be 1 GB.

When you are using import mode to publish reports, the pbix file exceeds the limit, then you need to consider the direct query mode.

 

Best Regards,
Liang
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

1 REPLY 1
V-lianl-msft
Community Support
Community Support

Hi @Anonymous ,

 

Specifically, Power BI leverages the xVelocity compression engine and works on a columnstore in-memory technology. In-memory columnstore technology compresses data and stores it in a compressed format.

When using import mode, the size of the model is limited. Your power bi (or file) model cannot exceed 1 GB. Typically, the maximum account capacity is 10 GB, but the maximum capacity per file must be 1 GB.

When you are using import mode to publish reports, the pbix file exceeds the limit, then you need to consider the direct query mode.

 

Best Regards,
Liang
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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors