Skip to main content

Power BI

New

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

Vote (16) 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 (2)
Michael's profile image Profile Picture

99cac602 3e5b-493a-9144-8082dd36c3cc 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

5087f8f7 f995-4045-b214-566136f5c9d8 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