This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
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
Solved! Go to Solution.
Hi @Anonymous,
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. ![]()
Regards
Hi @Anonymous,
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. ![]()
Regards
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 ?
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 55 | |
| 42 | |
| 26 | |
| 24 |