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,
Thanks Akash_Varuna for Addressing the issue.
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Vinay Pabbu