data from Application Insights

[Anonymous]

Hello, I need help with rendering data from Application Insights in Power Bi.

Current situation:

I have telemetry on app that log 10+ unique status of app.

But past 24 hours I have only 6 category. And another 24 hours (or other time range) I can have different data. In short - type of data that I receive is different every time I reload query.

this is how it looks after i rename rows to my custom names.

everything is fine until now. If I update the query with other than this data, it goes all again to original names, not my renamed.

Is there any way how can I rename my rows and If I update M Query with less or more data it remember my renamed rows?

Or it is possible to creat custom table, rename row, and If no data arrive from M Query give it 0 count_ ?

Please help me, I am stuck on this more than week 😞

Thank you

Ivan

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Adding a conditional column based on your name column should work in your scenario.