Forum Discussion
Service Principal Authentication on Web V2 connection type on On-Premises Data Gateway
Conclusion: Unsupported.
As per Microsoft documentation (Azure Data Lake Storage Gen2 - Power Query | Microsoft Learn😞
- The service principal authentication type isn't supported when using an on-premises data gateway or a virtual network (VNet) data gateway.
I've contacted Microsoft Fabric support, who told me there is no ETA for implementing this feature.
The link that you've shared for https://admin.powerplatform.microsoft.com/ext/DataGateways is exclusively to be used with the PowerPlatform dataflows. Not the Fabric nor the Power BI Dataflows. They do not share the same credential storages.
The correct url to use in Fabric would be --> https://app.powerbi.com/groups/me/gateways
Nevertheless, if you are planning to use a connection inside of Dataflow Gen2 then we recommend creating the connection inside of Dataflow Gen2.
If what you're trying to do is create a connection for a Web activity in Data Pipeline, then please let us know. Web V2 is only for Data Pipelines.
I've tried to create the connection in the On-Premises Gateway via:
- https://admin.powerplatform.microsoft.com/ext/DataGateways, both as a "Web" and as "Web V2";
- https://app.powerbi.com/groups/me/gateways, both as a "Web" and as "Web V2";
- Directly on Dataflow Gen2 "Get data" option, both as "Web Page" and as "Web API".
In all those cases I wasn't presented the option of Service Principal authentication.
Isn't Service Principal authentication supported when I use an On-Premises Gateway?