Forum Discussion
SSAS Tabular Vs SSAS Multi Dimensional
sdjensen ps do you know where i can find what is not possible to do in MDX direct query vs Tabular direct query?
Here is some of the things that currenly doesn't work with live connection to SSAS MD:
- Q&A
- Quick Insights
- Creating report-level measures
- Quick measures
- See Records
- Forecasting on line charts
- Clustering on scatter charts
- Explain increase/decrease
SSAS MD features that isn't currently supported by Power BI:
- Cell security – you will not be allowed to connect!
- Actions
- Named sets
- Binary images stored in dimension attributes
- Hiding unknown members
- HTTP connections
- Translations
- Setting (most) connection string properties
- Writeback
sdjensen oh wow thats a big one, role based security doesn't work with mdx and direct query in power bi?
My post didn't mention RLS, but you can read about the limitations about RLS here: https://docs.microsoft.com/en-us/power-bi/service-admin-rls#limitations
RLS has never been used for live connections to Analysis Services this also apply to Tabular.
"Only ETL, and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model."
sdjensen yes the scenario here is to implement role based security in an MDX cube, using a direct query connection on Power Bi Report Server, sorry i dont quite understand what you saying it does work or it doesn't? will check out the documentation