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.
lbendlin
Super User
Super UserWhy not parse the JSON directly in Power Query? Or stuff it into a SQL database and then run SQL queries against that?