Forum Discussion
Dataflows Gen1 do not have a credential type option Web API for Web.Contents
- 1 year ago
Thank you for contacting the Microsoft Fabric Community Forum.Currently, Dataflows Gen1 do not support the Web API credential type for use with the Web.Contents function. This is a known limitation, as Gen1 dataflows only allow a limited set of authentication methods: Anonymous, Basic, and Organizational Account (OAuth2).
Dataflows Gen2 in Microsoft Fabric do support Web API connections, but there are still some authentication limitations. The Web API connector in Gen2 supports only a few credential types: Anonymous, Basic (Username/Password), Organizational Account (OAuth2), and Windows. At this time, custom headers or bearer tokens for Web API authentication are not fully supported as they are in Power BI Desktop.
If your API requires advanced authentication, such as service principal or token-based headers, you may face restrictions with Dataflows Gen2. While Gen2 does offer improved connector support, Web API authentication options remain limited and may not cover all enterprise API integration requirements.
For additional details, please refer to the official Microsoft documentation provided below.
Set up your Web connection - Microsoft Fabric | Microsoft LearnRegards,
Karpurapu D,
Microsoft Fabric Community Support Team.
"real type" is very, very relative. There is a massive disconnect between what column types Power Query supports and what column types Power BI (DAX) and Fabric support.
Data types in the context of Power Query naturally as that was the domain of the original post... Power Query M type system - PowerQuery M | Microsoft Learn