Issue with Paginated report on Power BI premium capacity overloaded message

[Gopi_ks]

I have deployed few power BI paginated reports and it was working fine.

Suddenly started getting the below error message on each paginated report and then it takes a while to render the report for each and every operations. It is annoying to check the report every time and changing the parameter vaues.

Kindly let me know how to resolve this issue and how to limit the data from the data source connection itself.

I am using 'Azure analysis services model' as data source.

Thanks in advance.

[Gopi_ks]

Hi, 
I am still facing lot of records loading in browser irrespective of Paramater values whether it is for one month date range or one day date range.
Kindly suggest.

[Hariharan_R]

Hi,

Looks like your report used exceeds the alloted resource. Please check the Premium capacity metrics app for more details. If you want to filter then you need to filter in your Paginated report either hardcoded filter or using parameters.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[Gopi_ks]

Thank you Hariharan.

It seems the filters and parameters restrict the data after fetching all the records from data source.
But, I need to restrict the data from the data source itself for the selected filters.
Retriving data itself taking long time and then the report applies the filters and parameters on the data.
Correct me if I am wrong.

[Hariharan_R]

Hi,

 If you use parameters in the dataset then it will restrict the data that will fetch only limited data from your underlying data source. This is the most recommended option to filter your records. 

Report filters are applied on top of the dataset result. I would recommend you to use parameters to get the minimal records to reports and hope it will not exceed the resources.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin