Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone ,
We need some suggestions and ideas on automated dataset refresh Power BI service >> Power BI gateway >> SQL server . We have below observation.
1. Execute SQL on SQL server >> SSMS takes : 24 minutes (5.5 Lac approx. records)
2. Manual refresh using SQL Server >> Power BI desktops takes : 100 Minutes.
3. Automated refresh SQL server >> Power BI gateway >> Power BI service takes : 60 minutes.
Note : All applications are hosted in Azure environment and we already optimized SQL query.
@Anonymous If you've already optimized the SQL query portion then I would suggest looking at the transformation layer in Power BI (Power Query) - are you doing any heavy transforms there or is it more of a data volume issue? Are you seeing any memory constraints or thresholds being maxed out on SQL while processing?
The points of contact that you can effect would be on the SQL side, or the Power BI Desktop ingest/model. You can't performance tune PBI Service refresh.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.