Forum Discussion
Solved
Trouble with loading Salesforce backup data through Phyton script
Hello all, Currentely we have the the problem that we cannot perform our full upload of Salesforce data into Power BI using a Phyton script. The goal is that we load in the past 100 weeks of 2 b...
Run your data operations outside of Power Query/Power BI, save the results as CSV or Parquet, and then ingest them in Power BI.
If you're running into issues with inconsistent JSON from Salesforce backups, it's often due to changes in field structure or missing data across records. You can try cleaning it up with Python and Pandas, but it gets tricky fast. If your goal is to back up and restore Salesforce data reliably, you might want to consider a tool like Skyvia Backup – it handles structured backups automatically and lets you restore specific records or fields when needed, no scripting required.