cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubham
Helper V
Helper V

power bi store data in byte?

Hi,

 

i have one query for storing data in bytes.

for example if I am using SQL DB as datasource and in DB i use decimal (38,10) and int datattype columns.

at SQL DB front these columns take 17 byte and 4 byte for storing data value.

 

So, if I import this table in PBI desktop then what would be the size in bytes PBI stores.

 

Thanks,

Shubham

 

 

 

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft
Microsoft

Hi @Shubham,

 

In Power BI, VertiPaq stores each column in a separate data structure. This simple fact allows the engine to implement some extremely important compressions and encoding. Here is a good article about VertiPaq, which could help you understand how the VertiPaq engine stores data in Power BI. Smiley Happy

 

Regards

View solution in original post

2 REPLIES 2
v-ljerr-msft
Microsoft
Microsoft

Hi @Shubham,

 

In Power BI, VertiPaq stores each column in a separate data structure. This simple fact allows the engine to implement some extremely important compressions and encoding. Here is a good article about VertiPaq, which could help you understand how the VertiPaq engine stores data in Power BI. Smiley Happy

 

Regards

View solution in original post

Thanks @v-ljerr-msft for sharing, it is very informative and detailed document.

so consider this, I can say Power BI use VertPaq engine and it has many methods to compress the data and these methods would be applicable according to the nature of data.

 

Am I right ?

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors