search

M365-DenzilFernandes / PowerBI-M365Licensing

Sample PBIX Reports for analyzing usage and consumption of M365 Licenses
4 stars 1 forks source link

Failing 2nd query in the BI dashboard. #1

Open AndrewMarsh24 opened 3 years ago

AndrewMarsh24 commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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.