topic Re: Anybody is using Azure KeyVault connector? in Developer

Anybody is using Azure KeyVault connector?

jaryszek — Thu, 10 Apr 2025 12:55:49 GMT

Hi Guys,

I am using key azure connector and noticed after implementing it that the time for uploading small report increased significally.

Connector is here:
https://www.bibb.pro/post/securing-your-api-power-bi-data-with-azure-key-vault#:~:text=Using%20Azure%20Key%20Vault%20in,via%20Power%20BI%20M%20Code

Has anybody issues with customer connectors publishing times?

Best,
Jacek

Re: Anybody is using Azure KeyVault connector?

lbendlin — Thu, 10 Apr 2025 13:49:20 GMT

That custom connector seems to fetch all your secrets from the vault. Depending on how many you have stored there this could take a considerable amount of time. Maybe ask the connector developer for an option to specify individual items to retrieve.

Re: Anybody is using Azure KeyVault connector?

jaryszek — Thu, 10 Apr 2025 14:17:26 GMT

I have only one 🙂

But when I am putting this connector in the query like:

The publishing time istaking 2 h instead of few seconds like usual.
What can be the cause?

Best,
Jacek

Re: Anybody is using Azure KeyVault connector?

lbendlin — Thu, 10 Apr 2025 14:54:03 GMT

Use SQL Server Profiler to visualize the refresh and identify the part that takes so long.

https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/

Re: Anybody is using Azure KeyVault connector?

jaryszek — Fri, 11 Apr 2025 06:57:32 GMT

Thanks the case is that refreshing dataset is fine on desktop but when I am trying to publiush report - time is increasing up to 2 or more hours.
After getting rif ofthis statement with Azure KeyVault connector - everything is fast and nice and whole publishing takes few seconds.

Best,
Jacek

Re: Anybody is using Azure KeyVault connector?

lbendlin — Fri, 11 Apr 2025 11:03:36 GMT

Have you configured the gateway correctly?

Re: Anybody is using Azure KeyVault connector?

v-venuppu — Mon, 14 Apr 2025 10:13:23 GMT

Hi @jaryszek ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

Re: Anybody is using Azure KeyVault connector?

jaryszek — Mon, 14 Apr 2025 10:34:59 GMT

Hi,

why to do this if i am connecting to my azure key vault?

I used manual fron link with azure key connector and set up my gateway.

best,
Jacek

Re: Anybody is using Azure KeyVault connector?

jaryszek — Tue, 15 Apr 2025 06:15:06 GMT

Problem is not solved. Connector is very slow still.

Re: Anybody is using Azure KeyVault connector?

v-venuppu — Mon, 21 Apr 2025 12:17:54 GMT

Hi @jaryszek,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

When using Azure Key Vault, configuring the gateway correctly is essential, even if you are directly connecting to your Azure Key Vault. Here are some reasons why configuring the gateway is important:

The gateway ensures that your on-premises data sources can securely connect to Azure services. This is crucial for maintaining a secure and reliable connection to Azure Key Vault.
Proper gateway configuration can help optimize the performance of your data refresh and publishing processes. It ensures that the data transfer between your on-premises environment and Azure services is efficient.
The gateway provides an additional layer of security by managing the credentials and ensuring that the data transfer is secure.
If you encounter issues with the Azure Key Vault connector, having the gateway configured correctly can help in troubleshooting and identifying the root cause of the problem.
Here are some resources to get you started with On-Prem data gateway
What is an on-premises data gateway? | Microsoft Learn
How to download: Install an on-premises data gateway | Microsoft Learn
Configuration in Service: Add or remove a gateway data source - Power BI | Microsoft Learn

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!