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)
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
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.