Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.