Create a Cost Allocation app for PBI Premium License cost

[D_Lav]

Hi!

Hope anyone have a good idea here:) im trying to create a report that visualise how much of our P1 Premium capacity resources is being used. This is something that we will use for billing purpose inside the organisation. As a P1 cost 5000USD we need to reallocate this cost in the organisation based on some metric that shows us adoption/Usage inside my organisation. 

My thought is that we could show this based on how much CPU on avarage the diffrent datasets are using and then map that to underlying department in my organisation.

I found the attribute [AvarageCPUTime] inside "QueryMetrics" table when i connected to PremiumCapacityMetricsApp which i can present per dataset name. I dont really now how this attribute is built and how it works. Cant find any information online either. 

Does anyone know anything about this attribute or how i could use it for my above purpose? Or perhaps have done something similar and could share the idea:)

[lbendlin · Accepted solution]

In my opinion the cumulative query refresh duration is an important cost aspect, as it directly impacts the availability of render cores. That is especially important for import mode heavy scenarios.  For Direct Query this may be less applicable.