Forum Discussion

nnouchi's avatar
nnouchi
Helper I
7 years ago
Solved

Extracting Data from API and transform into tables

Greetings Power BI community,   I am having trouble understanding the steps necessary to extract and format data from an API source to be used practically in Power BI.  This is the outcome o...
Need Help
Show and Tell
Tutorial Requests
  • ImkeF's avatar
    ImkeF
    7 years ago

    Hi nnouchi,

    there is a very easy way to retrieve the TS-data from Quandl:

     

    let
    Source = Json.Document(Web.Contents("https://www.quandl.com/api/v3/datasets/LME/PR_NI.json?api_key=xxxxxxxx")),
    dataset = Source[dataset],
    ExpandAllQuandl = Table.FromRows(dataset[data], dataset[column_names])
in
    ExpandAllQuandl

    Works with all sources and will definitely refresh in the service as well.

nnouchi's avatar
nnouchi
Helper I
7 years ago

Okay, I have figured out how to extract the dataset of values and just renamed the columns as they would be in the column headers, however, I don't think this would work with any updated refresh since the data had to be manipulated and transformed.

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi nnouchi,

     

    I'm glad you made it. You can refresh it if you did all the manipulations and transformations in the Query Editor. Please refer to the snapshot below. The steps record all your operations. They will be applied to the new data. Please give it a try.

    Extracting-Data-from-API-and-transform-into-tables

     

     

    Best Regards,
    Dale