Power BI - Read Only routing - SQL AlwaysON

Allowing PowerBI Service to connect to SQL Server read-only secondary when connecting to AlwaysON setup. This works perfectly fine in PowerBI Desktop. It does not work in PowerBI Service. We had to use OLE DB provider to make it happen when using onprem gateway. We can not migrate to VNet gateways because OLE DB is not supported in VNet gateways. So we have to live with OLE DB provider.