cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
D_Lav
Frequent Visitor

Create a Cost Allocation app for PBI Premium License cost

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:)

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

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.

View solution in original post

1 REPLY 1
lbendlin
Super User III
Super User III

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors