How can we improve Power BI?

DAX for SSAS Multidimensional

Enable DAX support for reports using live connection to SQL Server Multi-Dimensional in Power BI Desktop and Power BI Service. Simple DAX measures like: Amount in Thousands = [Measure]/1000. TGT Variance = [Actual]-[Target] etc. could be created on report level and would be massively useful. Now I must extend enterprise data model (cube) every time when I need something like [Measure]/1000 in one Power BI report. This is crazy. I understand, that because Multidimensional don’t understand concept of Table, so some DAX functions will not work. This should be developer’s responsibility to develop and test. If intellisense doesn’t work also isn’t an issue. Better some functionality, then none.

73 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Jiri Neoral shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.