Forum Discussion

Trish_Rye's avatar
Trish_Rye
Icon for Helper I rankHelper I
1 year ago
Solved

base-2 or base-10 system when reporting semantic model sizes on Power BI Service?

Hi,

Does Power BI Service use base-2 or base-10 system for reporting dataset (semantic model) sizes?

  • lbendlin's avatar
    lbendlin
    1 year ago

    Tell your stakeholders that is a meaningless KPI. Instead, learn about Fabric pricing for storage.

6 Replies

  • the compression algorithms are bit based.  but a rather good approximation is to assume that everything behind the scenes is turtles text all the way down.

    • Trish_Rye's avatar
      Trish_Rye
      Icon for Helper I rankHelper I

      Hi,

      I am not sure I understand your answer... Maybe I should have been more precise.

      I am extracting info on unused semantic models' size using this api:
      https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-unused-artifacts-as-admin

       

      Since data is in MB, I would like to convert them into GB in my KPIs. I asumed that since this is a storage measurement, I should do it like this: 

      size in GB = Size in MB / 1024

      But you are saying it's bits (not bytes as above)  which would be strange I think, as it's mostly used for network speed...

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        Ah, you want to know if it is counting in GiB or in GB.  As I said - it doesn't matter. The compression has a much bigger impact.