PowerBI performance is very poor, high CPU, memory at 100% when connecting to an Azure SQL database.

[Anonymous]

Hi,

I just noticed that the performance for my report is very poor when using Import and a SQL server database connection: high CPU, memory 100% - app not responsive. I have collected the perfoemnce logs in case need to investigate.

Are there any recomandations or guidelines to improve performance?

Thaks,

George

[v-lili6-msft]

hi @Anonymous 

First, make sure your Desktop is up to date.

what size of the dataset that you import into power bi desktop?

 different size of data model loaded into Power BI desktop will consume different memory. Also, manay factors might affect the memory utilization of imported data model, please refer to below links to get more suggestion about how to check the memory usage of your Power BI Desktop data model and how to reduce memory utilization:

Power BI Performance Tips and Techniques

Power BI Desktop – Memory Usage

Performance Tip for Power BI; Enable Load Sucks Memory Up

and also try to disable "allow data preview to download in the background"

Here is a blog which describes this option. Please refer to the link below.

Best regards,
Lin