Failing 2nd query in the BI dashboard.

[AndrewMarsh24]

Loving this, have set it up and the flow is populating the Get-SubscriberSku.csv with data.

on the BI dashboard, i can see two queries, the first runs ok, but the second is looking for a file that doesn't exist or a tab in the sheet that isnt present. Get-SubscriberSku-E5-Developer.csv

That CSV file doesnt exist. Is there a 2nd PA flow thats generating that second file?

[M365-DenzilFernandes]

Thanks, Andrew. Good catch on the 2nd query, that's correct. When I shared this I had two flows, one for each tenant I was managing. This sample had data from one E5 Trial as well as my E5 Developer Tenant. To resolve, either duplicate another PA query to another tenant or delete the query from the PBIX file.

[AndrewMarsh24]

Ah makes sense now. good call

We are looking at also tracking the numbers by day/month etc just to monitor trends and peaks to balance out our renewal process for licences.