cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
M-Anant
Frequent Visitor

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. 

 

However, post deployment, we are getting error messages like -  

Function 'PREVIOUSYEAR' is not supported in DirectQuery mode. 

 

Is there any configuration required on the RS to enable it ? Or Anything else ? 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team
Power BI Team

Re: ReportServer - Unrestricted Measures - Direct Query

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.

View solution in original post

7 REPLIES 7
Microsoft
Microsoft

Re: ReportServer - Unrestricted Measures - Direct Query

Hi @M-Anant,

 

I could reproduce the same problem in my test. I have reported it internally to consult with PG. Will update here once I get any reponse from product team. 

 

Regadrs,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yousra Advocate I
Advocate I

Re: ReportServer - Unrestricted Measures - Direct Query

Hello,

 

Any update on this?

I'm having the same problem while using the TOTALYTD function.

M-Anant
Frequent Visitor

Re: ReportServer - Unrestricted Measures - Direct Query

Hello All, 

 

Is there a way to reach out to the product team ? 

This issue is a show-stopper for us now and we need a quick turnaround. 

 

We could see that this issue does not exist on Power BI Online. 

Is there any Product Backlog for the next release visible to users ? 

 

Any response is appreciated. Thanks. 

cdionne
Frequent Visitor

Re: ReportServer - Unrestricted Measures - Direct Query

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 Advocate I
Advocate I

Re: ReportServer - Unrestricted Measures - Direct Query

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

dlshryoc
Frequent Visitor

Re: ReportServer - Unrestricted Measures - Direct Query

 

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.
Power BI Team
Power BI Team

Re: ReportServer - Unrestricted Measures - Direct Query

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.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.