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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Hadi2021
Helper II
Helper II

Investigating Unexplained Growth in Power BI Dataset Size

Hi all 
I have a Power BI Desktop file published to a premium dataset that has quadrupled in size over the last four months.
I'm certain that neither my data nor my scripts are responsible for this unusual increase in size.
Is there a tool or method available that can help me compare the old version with the new one to understand why this increase occurred?
Thanks in advance.

1 ACCEPTED SOLUTION
3CloudThomas
Super User
Super User

yes, you can download the file from the service and give it a new name.

open the file in Power BI Desktop, then use DAX Studio to connect. (if you do not have DAX Studio, download for free from sqlbi.com)

3CloudThomas_0-1713269978811.png

In the Advanced menu, select View Metrics.

3CloudThomas_1-1713270033138.png

There is a list of tables and columns that you can examine for size. Compare this to the other pbix file that is smaller.

3CloudThomas_2-1713270118085.png

 

View solution in original post

1 REPLY 1
3CloudThomas
Super User
Super User

yes, you can download the file from the service and give it a new name.

open the file in Power BI Desktop, then use DAX Studio to connect. (if you do not have DAX Studio, download for free from sqlbi.com)

3CloudThomas_0-1713269978811.png

In the Advanced menu, select View Metrics.

3CloudThomas_1-1713270033138.png

There is a list of tables and columns that you can examine for size. Compare this to the other pbix file that is smaller.

3CloudThomas_2-1713270118085.png

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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