Forum Discussion

prabhatnath's avatar
prabhatnath
Advocate III
2 years ago
Solved

Dataflow Scenario to Update few columns separately

Hello Friends,

 

I am new to Power BI Service Dataflows.

 

At present I have my Dataset in Power BI and being consumed by the report. The Dataset is pulling workitems data from Azure DevOps. The datarefresh takes around 10 min. All good till now.

 

I wanted to add another column in the Dataset that can be achived by calling an API  URL (as this information is not available directly) using Json.Document(VSTS.Contents(APIURL)) and passing the row content Id (ex: WorkItemId) in the API call. This is working fine but the refresh time increased to 1.5 Hrs.

 

So is there a way I can separate this step from the main datatransformation, that load and transform the data, so that only this step can be executed on the loaded Dataset once a day or twice a day only? Usally in Power BI Dataset that may not be feasible as we can have just one refresh schedule for the Dataset.

For this I was thinking if Dataflow in Power BI service can help where I can have one Dataflow that loads the Basic Data without the additional column and somehow I have another Dataflow as "Linked Table from Another Workflow" option to have the step that will just call the API for each ID but add the column to the main dataset?

 

Or Please suggest how can I achive this where main data is loaded separatly and couple of columns to be updated on the main table separatly?

 

Thanks,

Prabhat 

 

  • Hi prabhatnath 

    This is a good option

     

    But you will have to update the dataset to the underlying Dataflow.

     

1 Reply

  • aj1973's avatar
    aj1973
    Community Champion

    Hi prabhatnath 

    This is a good option

     

    But you will have to update the dataset to the underlying Dataflow.