Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Allow dataflows to connect to REST API's that require a key as a query parameter.

    Vote (21) Share
    Michael's profile image

    Michael on 14 Jan 2019 23:16:08

    Currently you can't connect to a REST API that requires a key in the query parameter. This limits the available data sources.

    https://community.powerbi.com/t5/Issues/Using-REST-API-as-source-for-dataflow/idi-p/578554

    Comments (3)
    Michael's profile image Profile Picture

    Guoxing Yan on 15 Sep 2020 00:36:26

    RE: Allow dataflows to connect to REST API's that require a key as a query parameter.

    Must required feature. By passing dynamic parameter can solve many many unsupported functions by ourselves.

    Michael's profile image Profile Picture

    Andrew Hacking on 06 Jul 2020 00:04:26

    RE: Allow dataflows to connect to REST API's that require a key as a query parameter.

    Seems this feature has been implemented in Web.Contents using the ApiKeyName option.

    Refer https://docs.microsoft.com/en-us/powerquery-m/web-contents

    Michael's profile image Profile Picture

    Ragavan Rajan on 06 Jul 2020 00:03:18

    RE: Allow dataflows to connect to REST API's that require a key as a query parameter.

    Must required feature. Our APIS are still using BASIC authorization