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.

     

     

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
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.