Anybody is using Azure KeyVault connector?

[jaryszek]

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

Has anybody issues with customer connectors publishing times? 

Best,
Jacek

[v-venuppu]

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.

[jaryszek]

Problem is not solved. Connector is very slow still.

[v-venuppu · Accepted solution]

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

  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! 

[lbendlin]

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.

[jaryszek]

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

[lbendlin]

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/

[jaryszek]

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

[lbendlin]

Have you configured the gateway correctly?

[jaryszek]

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