[CoE Starter Kit - BUG] App Usage has stopped collecting

jimpreston29 commented 1 month ago

Does this bug already exist in our backlog?

[X] I have checked and confirm this is a new bug.

Describe the issue

Hi - Our CoE is using BYODL. Our Apps usage numbers in the BYODL dashboard power bi reports only show model driven apps. the canvas apps stopped about 5 weeks ago If i go to the dataflow in the power bi workspace , i see records for the dates since it stopped working. If i click on the 'source'from the dataflow table (see image below), i get 'we encountered an unexpected error for the Azure Data Lake Storage Gen2 - i am troubleshooting this but posting here aswell in case anyone has seen this

Expected Behavior

show app usage for canvas apps. its showing zero

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.23

What app or flow are you having the issue with?

no flows are part of this

What method are you using to get inventory and telemetry?

Data Export

Steps To Reproduce

view app usage dataflow results

Anything else?

AB#3804

Jenefer-Monroe commented 1 month ago

I'm afraid I dont know what's happening for you. I do see this working on my side. Perhaps ensure you are using the DFs from the Jan 2024 release and that the Datalake URL is in a format like this: https://storageaccountname.dfs.core.windows.net/powerplatform

ryan-stuchbery commented 3 weeks ago

Hi, We're experiencing the same issue with app usage data not making it through the data flow into the Dv table. It appears to have started at around 22-May. Investigating the dataflow, I can see plenty of usage data in the first screenshot below, but it is filtered away at the next step in the second screenshot. However, I don't know how to fix this.

ryan-stuchbery commented 3 weeks ago

When we started experiencing the issue we were also using Core Components 4.23 but I have just upgraded to 4.32.2 and the issue has not resolved itself.

Jenefer-Monroe commented 3 weeks ago

Ryan, I think your issue is different as I believe you are using the Dataflows for import into DV tables while OP is using the DF for the PowerBI. They are different Dataflows and behave diferently. Can you post your own issue as a result ?

Jenefer-Monroe commented 2 weeks ago

closing out as no further action for starter kit team

ryan-stuchbery commented 2 weeks ago

We figured out the issue we were experiencing with the app usage dataflow. The app usage data is being merged with the admin_app table using the "Admin_App" column but it should have been using the "Admin_appidstring" column

microsoft / coe-starter-kit