Skip to main content
Microsoft Idea

Power BI

Needs Votes

live query for Analysis Services DMVs

Vote (20) Share
's profile image

on 22 Oct 2017 23:52:57

There are a couple of options for live queries
- Azure SQL DB
- Azure SQL DWH
- SQL DB
- Oracle
- Terradata

and you can connect live to Analysis Services - but only a model.

I do not unterstand why I cannot create a live query to a random DAX Query / MDX Query. Why is there only the whole model.
And why can I not connect live to DMVS in Analysis Services.

I put a monitoring dashborad together, and for SQL Server I can use all system DMVs from SQL Server and get a "live" view.
Why is this not possible for AAS - but still being possible to connect to a whole model live?
Why canßt I put a DAX / MAX Query like "select * from $system.discover_sessions" into the Query and get that live from AAS.

Since its everywhere said the Analysis Service Connection is possible to be live - make the whole AS DMVs queryable like a model. Just enalbe direct query for an OLEDB Analysis Service Connection.

Thanks

Comments (2)
's profile image Profile Picture

Dmitry Ponkratenko on 17 Dec 2021 10:31:30

RE: live query for Analysis Services DMVs

separate idea for oledb in paginated reports - https://ideas.powerbi.com/ideas/idea/?ideaid=22dce8e1-235f-ec11-a3ef-281878e608e9

's profile image Profile Picture

Dmitry Ponkratenko on 16 Dec 2021 12:08:52

RE: live query for Analysis Services DMVs

also we need SSAS OLEDB access for paginated reports in PBI Premium, which was working perfectly on SSRS and PBI RS...
it's preventing one of our customer from migrating to Premium from PBI RS.