topic Track Power BI Capacity overloaders in Developer

Track Power BI Capacity overloaders

Anonymous — Tue, 15 Aug 2023 13:11:21 GMT

Hi,

I'm trying to set up "Tracking for Power BI Capacity overloaders" by following this description
https://pbi-guy.com/2023/07/11/track-power-bi-capacity-overloaders-with-power-automate/.

Looks like it is working for one of our P2 capacities, but we also have two P1 capacities that it looks like data is missing.

If I connect in DAX Studio to the "Premium metrics apps" dataset and execute this dax code on the P2 capacity I get correct answer and the correct timestamp for the latest overload if I compare with the metric app.

// ------------------------------------------------------------------------------- // Get the Overloader Dataset ID // ------------------------------------------------------------------------------- DEFINE VAR CapacityID = "XXXXX" VAR vHourDiff = 48 EVALUATE SELECTCOLUMNS ( FILTER ( CALCULATETABLE ( ADDCOLUMNS ( ADDCOLUMNS ( SUMMARIZECOLUMNS ( Items[capacityId], Items[WorkspaceName], Items[ItemId], Items[ItemName], Items[ItemKind] ), "Last_OverloadTS", CALCULATE ( MAX ( ThrottlingByItem[OperationStartTime] ) ), "Sum_throlltletime", CALCULATE ( SUM ( ThrottlingByItem[count_throlltletime] ) ) ), "HourDiff", DATEDIFF ( [Last_OverloadTS], NOW (), HOUR ) ), ThrottlingByItem[count_throttledoperations] > 0 ,Capacities[CapacityId] = CapacityID ), [HourDiff] < vHourDiff && [Sum_throlltletime] > 0 ), [capacityId], [WorkspaceName], [ItemId], [ItemName], [ItemKind], [Last_OverloadTS], [Sum_throlltletime] )

But for my 2 other P1 capacities I do not get any data but I can see I have overloading in the app.
I have also notice that if I query this table I also only having data for the P2 capacity.
EVALUATE
VALUES(UtilizationByHour[PremiumCapacityId])

But all capacities is in table 'Capacities'

EVALUATE
Capacities

What am I missing?

Re: Track Power BI Capacity overloaders

lbendlin — Wed, 16 Aug 2023 22:59:33 GMT

I connect in DAX Studio to the "Premium metrics apps" dataset

How? That app should not be on a premium workspace to avoid skewing the data.

Re: Track Power BI Capacity overloaders

Anonymous — Fri, 18 Aug 2023 06:19:02 GMT

Thanks for info, I didn't know that the "Premium metric app" should not be on a premium workspace.
I will move it out from premium than and then I guess this article is not valid longer.
https://pbi-guy.com/2023/07/11/track-power-bi-capacity-overloaders-with-power-automate/

Re: Track Power BI Capacity overloaders

dtjdtj — Thu, 14 Sep 2023 13:15:33 GMT

Is there any reason behind why data is being skewed once capacity report is stored in Premium? Is it mentioned somewhere in the documentation? In this case, PBI Guy solution is not valid, what's your opinion?

Re: Track Power BI Capacity overloaders

lbendlin — Thu, 14 Sep 2023 13:44:55 GMT

It's a standard tenet of control systems that a monitoring process cannot reside on the monitored asset, otherwise it will monitor itself and -worst case- create a positive feedback saturation.

Re: Track Power BI Capacity overloaders

dtjdtj — Thu, 14 Sep 2023 14:16:22 GMT

Thanks for the info! I excluded Capacity Metrics workspace from Premium and the report still shows overloaders which are not retrieved by the DAX query from pbi guy link (It seems you can still run DAX queries through Power Automate against a non-premium dataset). So same issue initially reported here still.

Re: Track Power BI Capacity overloaders

Anonymous — Tue, 03 Oct 2023 14:31:59 GMT

i did set the power automate as per the instructions and at the end i got stuck with this error

{"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (15, 58) Cannot find table 'ThrottlingByItem'."}},{"code":"AnalysisServicesErrorCode","detail":{"type":1,"value":"3241803779"}}]}}}

Any idea why this is complaning about the analysis services engine... i know dataset is nothing but a tabular model on workspace( as aas instance)... but still what is missing.???

Re: Track Power BI Capacity overloaders

Anonymous — Tue, 10 Oct 2023 21:39:29 GMT

so now pbi guy solution for capacity overloaders are no more working, cause 10/01 capacity metrics is depreciated and wont work anymore. have to get the DAX for Fabric Metrics monitoring.

Re: Track Power BI Capacity overloaders

odumna — Thu, 26 Sep 2024 18:33:32 GMT

Hi, seemeseeu
Do you resolve your problem? I have the same error ....