Support DMX Queries in Report Builder to support DAX queries with parameters - by Marco Russo

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


15
0
Sign in
to vote
ID 716793 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/5/2012 9:50:56 AM
Access Restriction Public

Description

DMX query editor is the only way to insert a DAX query in a Report if you use Report Editor in Visual Studio/SSDT. However, these reports cannot be edited in Report Builder.
Sign in to post a comment.
Posted by cyrusgreat on 6/18/2014 at 10:15 PM
Definitely MSFT should add DAX query designer with parameter support in report builder.
Posted by Marco Russo - SQLBI on 5/21/2014 at 2:58 PM
Sagar, I added a Step-by-Step guide in this blog post: http://sqlblog.com/blogs/marco_russo/archive/2014/05/21/write-dax-queries-in-report-builder-ssrs-dax-ssas-tabular.aspx
Posted by SagarSalvi on 5/13/2014 at 3:50 AM
DAX queries do work with Report Builder 3.0, simply you have to select Data Source type as "OLE DB" not "MS SQL Server Analysis Services". And add provider information in conenction string for example:
Provider=MSOLAP.5;Data Source=MyServer\tabular;Initial Catalog=MyDB

Posted by Arun..Singh on 5/13/2013 at 10:21 AM
We still do not have support for DAX in Report Builder. Anyone has any workaround?
Posted by cyrusgreat on 9/26/2012 at 11:24 PM
Why Microsoft doing this??? When a new tabular mode is developed in ssas, everyone expect main reporting tool (Report builder not powerview) support it. Don't let this new method to be ignored by developers, just add a DAX query desiner in reportbulider 3!!!