Forum Discussion

Bobster326's avatar
Bobster326
New Member
1 year ago
Solved

Need help with loading large data volume

Hi    I have to decicde between two routes,   I have a python script that paginates and pulls a JSON response, it also then filters with this JSON response another downloaded csv file, where both...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Bobster326 ,

    "Parsing the json response in power query?" - means that:

    Directly call the API in Power Query using M (no need to run Python in the query step).Use Power Query functions like Json.Document to extract and transform the JSON structure into tables.Then use Power Query's merge or join capabilities to filter/match the JSON results against your CSV data using mdr_report_key.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

    Thank you.

     

     

Bobster326's avatar
Bobster326
New Member
1 year ago

Hi lbendlin @what do you mean by parsing the json response in power query? Do you mean having the data frames load into power query than conduct these transformations? 

I think it's just because I am looking at filtering the results of the other downloaded csv file by matching mdr report key