can dax be used as an ssrs dataset query

db042190 61 Reputation points
2023-09-02T16:34:47.63+00:00

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,935 questions
0 comments No comments
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-09-04T01:23:22.1066667+00:00

    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: https://learn.microsoft.com/en-us/sql/reporting-services/what-s-new-in-sql-server-reporting-services-ssrs?view=sql-server-ver16#query-designer-support-for-dax-now-in-report-builder-and-sql-server-data-tools.

    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,

    Aniya

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.