Power BI service Automated refresh of Dataset

[Anonymous]

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.

• How we can reduce automated refresh time for datasets ?
• Feature in Power BI which can be used to decrease refresh time ?

Note : All applications are hosted in Azure environment and we already optimized SQL query.

[Seth_C_Bauer]

@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.