I have 54Lakhs records in Power BI report which comes from SQL table. When loaded records first time loaded in 30 min but when I try to refresh report after changes done in desktop it's taking more t...
Hi Shrutika,
You can limit useful data and visuals, optimize data model to improve performance. Also you can check which query takes long time to execute via SQL profiler. For detail information, you can refer to this document: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
Best Regards,
Qiuyun Yu