Forum Discussion

MartySchlafer's avatar
MartySchlafer
Regular Visitor
1 year ago
Solved

Dataflows Gen1 do not have a credential type option Web API for Web.Contents

Dataflows Gen1 do not have a credential type option Web API for Web.Contents.  Is this by design or is it emblematic of other subtle variances of Power Query in Power BI desktop, Power BI service, an...
  • v-karpurapud's avatar
    1 year ago

    Hi MartySchlafer 


    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 Learn

     

     

    Regards,

    Karpurapu D,

    Microsoft Fabric Community Support Team.