Home Dashboard Directory Help

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



Sign in
to vote
Type: Suggestion
ID: 716793
Opened: 1/5/2012 9:50:56 AM
Access Restriction: Public


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!!!
Sign in to post a workaround.