Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Support for parameterized DAX queries in the RS dataset editor. Currently the data mining text box is the only way to enter DAX queries.

Creating a Reporting Services dataset based on a DAX query driven by parameter values created using MDX queries is currently a nightmare. The process is complex using the DMX editor and string expressions in order to build a dynamic DAX query to be run against a tabular model. There are significant performance benefits using DAX queries vs. MDX queries when returning detail data sets for drill through reports against a large tabular model. I believe that creating better support for DAX queries within Reporting Services would help to drive usage of Analysis Services Tabular models and help Microsoft BI users unlock the incredible capabilities of the stack.
Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New