Usage: see connections from Power Automate to Semantic models?

[sasdfasdfsad]

Is there a way to see when a Power Automate flow or some direct DAX query is run semantic models?

[cengizhanarslan · Accepted solution]

If the semantic model is on Premium or Fabric capacity, you can query Dynamic Management Views (DMVs) via:

• SSMS

• DAX Studio

• Tabular Editor

The two most useful ones:

SELECT *
FROM $SYSTEM.DISCOVER_SESSIONS

SELECT *
FROM $SYSTEM.DISCOVER_COMMANDS

These show:

• active sessions

• command type (DAX / MDX)

• start time

• user / caller

• client application (sometimes)

This is near-real-time only. Once the query finishes, it’s gone.

SELECT *
FROM $SYSTEM.DISCOVER_QUERY_STATS

This gives you:

• query duration

• CPU / memory

• rows returned

• user / effective identity

• client app

Limitations:

• short retention (minutes, not hours/days)

• no full DAX text

• entries can be evicted quickly under load

Another alternative might be using FUAM : https://github.com/GT-Analytics/fuam-basic

Using this will enable you to check queries that is executed on the Semantic Models as far as you open FUAM for monitoring.

[sasdfasdfsad]

Thank you!

Do you happen to know if Power Automate shows up in the client app?

[cengizhanarslan]

If it sends a query to the semantic model,  I believe it can be seen by using those mentioned ways.