Forum Discussion

M-Anant's avatar
M-Anant
Frequent Visitor
8 years ago
Solved

ReportServer - Unrestricted Measures - Direct Query

Hi Everyone,    For a new ReportServer implemented at a customer, when we enable Unrestricted measures for Direct Query (SQL Server 2016), things work fine on Power BI Desktop optimised for RS.   ...
  • mgmeyer's avatar
    mgmeyer
    8 years ago

    If you install the latest March release this issue has been fixed, if you're unable to upgrade just yet you can modify your msmdsrv.ini in the PBIRS\AS install folder. Looks for the EnableAllFunctions setting and change it from 0 to 1 and restart the server.

dlshryoc's avatar
dlshryoc
Regular Visitor
8 years ago

 

I'm not sure if this works in earlier versions of Power BI Report Server, but using the March 2018 release, I was able to extend the DAX functions available in direct query by making the following change:

 

In this file:

c:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\msmdsrv.ini

 

I changed this:

 
<EnableAllFunctions>0</EnableAllFunctions>
 
To this:
<EnableAllFunctions>1</EnableAllFunctions>
Once I made the change, I found the msmdsrv.exe process and killed it, forcing Power BI to restart the SSAS instance.