Forum Discussion
Auto-refresh for Power BI Custom Connector with Open API (Basic Auth)
Hi maredo To enable auto-refresh for Power BI a gaetway is needed for the questuions :
- Gateway Requirement: A Data Gateway is necessary for auto-refresh with external APIs.
- Best Resource: Install the gateway on an Azure Virtual Machine (VM), not the Azure App Service.
- Setup: Use a Windows-based VM in the same region as the App Service for optimal performance. Configure the gateway in standard mode for Power BI integration.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi maredo A single gateway instance on a VM is typically sufficient for handling multiple users and different credentials But if users spike then consider clustering multiple gateways on different VM
For the VM please check this discussion in reddit : https://www.reddit.com/r/AZURE/comments/n65hdu/d2s_v3_vs_d2s_v4_temporary_storage_vs_not/?rdt=35717
Hi maredo To enable auto-refresh for Power BI a gaetway is needed for the questuions :
- Gateway Requirement: A Data Gateway is necessary for auto-refresh with external APIs.
- Best Resource: Install the gateway on an Azure Virtual Machine (VM), not the Azure App Service.
- Setup: Use a Windows-based VM in the same region as the App Service for optimal performance. Configure the gateway in standard mode for Power BI integration.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Thank you Akash_Varuna
I have a few more questions to ensure the best setup:
- What VM instance type would be a good trade-off between cost and performance for running the Data Gateway efficiently?
- Since the gateway will serve multiple users with different credentials, would a single gateway instance on a VM be sufficient, or should I consider deploying multiple gateways across different VM instances?
Hi maredo A single gateway instance on a VM is typically sufficient for handling multiple users and different credentials But if users spike then consider clustering multiple gateways on different VM
For the VM please check this discussion in reddit : https://www.reddit.com/r/AZURE/comments/n65hdu/d2s_v3_vs_d2s_v4_temporary_storage_vs_not/?rdt=35717