Forum Discussion
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...
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
Community Support
Community SupportHi Bobster326 ,
I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.
Thank you.