cancel
Showing results for 
Search instead for 
Did you mean: 

Using REST API as source for dataflow

I am trying to use the below query as a datassource (a call to a REST API) for a dataflow. The api key is part of the query string so I have selected anonymous authentication. In the below query, MY_API_KEY represents my api key. The query works as expected in Power BI Desktop. However, if I copy and paste the "M" from the advanced editor in Desktop to the dataflow advanced editor (Blank Query) I get stuck in a loop where I'm asked "Please specify how to connect", I select anonymous, then I'm asked "Pleas specify how to connect" again. Am I missing something or is this a bug? ***************************************************** let Source = Json.Document(Web.Contents("https://api.stlouisfed.org/fred/series/observations?series_id=" & "MPRIME" & "&api_key=" & "MY_API_KEY" & "&file_type=" & "json")), observations = Source[observations], #"Converted to Table" = Table.FromList(observations, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"realtime_start", "realtime_end", "date", "value"}, {"realtime_start", "realtime_end", "date", "value"}) in #"Expanded Column1"

Status: Accepted
Comments
Moderator

Hi @r529,

 

I have reported this issue internally: CRI 94777889. Will keep you update once I get any information. 

 

Best Regards,
Qiuyun Yu 

Moderator
Status changed to: Accepted
 
Visitor

Hello @r529

 

Currently, using API key as a query parameter is not supported in dataflows.

 

Please feel free to propose adding this capability via Power BI User Voice.

 

Rregards,

 

Nimrod Gal-Oz