Forum Discussion
Anybody is using Azure KeyVault connector?
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
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 LearnIf 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!
9 Replies
- lbendlinSuper User
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.
- jaryszekSuper User
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- lbendlinSuper User
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/
- jaryszekSuper User
Problem is not solved. Connector is very slow still.
- v-venuppuCommunity Support
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 LearnIf 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!