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
    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.