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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Also having this issue as well, and will be a major issue with our upcoming release.   Hoping the more who complain the more likely this is resolved...

Yousra's avatar
Yousra
Advocate I
8 years ago

Anonymous M-Anant to bypass this issue you can try to get the measures you want from the initial query. 

 

Example: if you want to have the TOTALYD measure, the query has to return the cumulative total to this day. You can still use the basic arithmetic functions in Power BI with direct query.