can dax be used as an ssrs dataset query

db042190 61 Reputation points

hi, years ago mdx was automatically generated by ssrs even on tabular model cubes. In fact i think folks would get ssrs to generate mdx over multi dimensional cubes even if they had no intention of ultimately using the query from ssrs.

I vaguely remember it being impossible to code dax as the code behind an ssrs dataset. Is it possible to use dax as a dataset query over a tabular cube in ssrs?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,548 questions
0 comments No comments
{count} votes

Accepted answer
  1. AniyaTang-MSFT 9,601 Reputation points Microsoft Vendor

    Hi @db042190

    According to the documentation, native DAX queries can now be created against supported SQL Server Analysis Services tabular data models in Report Builder and SQL Server Data Tools.

    For more details, you can refer to this link:

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,


    0 comments No comments

0 additional answers

Sort by: Most helpful