Forum Discussion
Percentile Calculation
The premium license can't be used for report server, it is used in pbi service. And admin can modify capacity setting in service with may be meet your needs. But I can’t be 100% sure because I don’t know your specific situation. If you have(If your report server key is obtained from premium), you can try to publish the report to service, add a gateway, and see if it can be displayed.
Reference:
What is Microsoft Power BI Premium? - Power BI | Microsoft Docs
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
Hi, Gayathri999268
You can check the limitation:
For example, you can aggregate 10 million rows with your query that runs on the data source. The query accurately returns the results of that aggregation to Power BI using DirectQuery if the returned Power BI data is less than 1 million rows. If over 1 million rows are returned from DirectQuery, Power BI returns an error (unless in Premium capacity, and the row count is under the admin-set limit).
For more details, you can see the below:
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs
For your situation, If you have premium capacity, It may be displayed normally on the service. If not, I'm afraid it's hard to do.
What results do you want to show? You can share the measure formula, let’s see if it is possible to simplify it.
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