Forum Discussion

Gayathri999268's avatar
Gayathri999268
Frequent Visitor
4 years ago
Solved

Percentile Calculation

Hi All,   I am facing an issue with percentile calculation in Power BI. I need to have Total, Average and percentile values of a column in Power BI with direct query mode. Total and Average are wor...
Need Help
Gayathri999268's avatar
Gayathri999268
Frequent Visitor
4 years ago

Thank you v-janeyg-msft  for your reply.

 

We are using Power BI report server.  Kindly please advise if we can set any limit to row count from admin side if the report is running on report server and how to do it

And actually the measure is very simple :

 

Percentile_25_Sal 

= CALCULATE(PERCENTILE.INC(EMP[SALARY],0.25),EMP[ACTIVE]=1)

 

The row count of this filtered dataset  is greater than 1M.

 

Thank you

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, Gayathri999268 

     

    Sorry, I'm afraid not. The limit of DQ should be the same on desktop for service and desktop for report server. I think the only thing you can do is to control the results returned by the query to be less than 10 million rows. After all, premium is paid, so it is powerful.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,
    Community Support Team _ Janey

    • Gayathri999268's avatar
      Gayathri999268
      Frequent Visitor
      4 years ago

      Thank you for the reply v-janeyg-msft .

       

      Unfortunately I cannot reduce the dataset size as per the client requirements. Just for my understanding to proceed ,Could you please clarify how to set this limit incase we acquire a premium license for Power BI Report server.

       

      Thanks in Advance.