Is it possible to get the whole list of url power bi desktop will try to connect when opening?

[alexyin1053]

Hi all, 

Currently we have installed power bi desktop(2024.05) in our company's product environment, while having an issue that it takes around 3 minutes to open a blank .pbix file and takes forever to open a .pbix file.

Following is the effort we've tried:

1. Checked CPU and ram(32G): Takes around 10% usage at first then dropped to >1%

2. Tried to downgrade the version of power bi desktop to 2023.09 but issue remains.

3. Tried to remove network adapter, Power Bi desktop can be opened smoothly(<3sec)

4. Open proxy manual settings(Using server IP and 8080 port), Power Bi desktop can be opened smoothly(<3sec)

Based on the above information, we assume that DLP and proxy settings may be the reason affecting it. 

Is it possible to get the full list of url power bi desktop may try to connect so we can work with our IT group to see if it's possible to add them into white list.

Any suggestions would be appreciated,

Thanks!

[Anonymous · Accepted solution]

Thanks for the reply from amitchandak , please allow me to provide another insight: 
Hi  @alexyin1053 ,

Here are some common URLs that Power BI Desktop might try to connect to:

Power BI Service: https://app.powerbi.com

Azure Active Directory: https://login.microsoftonline.com

SharePoint Online: https://<your-tenant>.sharepoint.com

Azure Blob Storage: https://<your-storage-account>.blob.core.windows.net

Azure SQL Database: https://<your-server>.database.windows.net

Office 365 URLs: Various URLs for Office 365 services.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alexyin1053]

Dear Liu Yang,

Thanks for the information, I would like to update that our final solution is that we added some blocking rules on our server's windows defender so that the fail connection could be quickly received, resulting in opening power bi desktop quickly.

Thanks!

Best Regards,

Alex

[amitchandak]

@alexyin1053 , In Power bi desktop, Open File -> Options and settings -> Options

Go to Load data and clear cache. And Increase Data Management Cache.

Also use tools like temp memory cleaner to clear the system cache to speed up the performace

[alexyin1053]

Thanks for the reply but based on our testing, we don't think the problem is on the data management cache.