Need Assistance on Power BI Paginated Report - Performance Tuning

[JayanthKumarS]

Hi all,
We have developed a paginated report  with count of 180 columns and 1 lakh rows.
We are using Big query as a back-end and we are fetching the data using view by doing union all of 3 tables.
But it is taking more time (approximetely more than one hour) to display the data on the Power BI Service even with the minimal amount of data records ( i.e , 35 thousand).
Can you please help me with any performance tuning approach ?
Thank you!

[SnehalSutar]

Thank you for the reponse.

We tried with adding filters as well however it is not working for 180 columns and for huge data.

Earlier we tried on table having 90 columns and 35k records. It is working fine for that table.however not for 180 columns and huge data.

[Gayatri_D05]

Hi @JayanthKumarS 
The datasets you might be using for the paginated reports are those optimized, also you could check if you can improve the performance by some filters. 
Doing a RCA would be recommended on where exactly the service is facing delay.

If your requirement is solved, please make THIS ANSWER as SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.😊