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.
That is definitely a good option to explore and could be a suitable solution.
Do you have any idea why the problem occurs if I run it through PowerBI
The Python scripting in Power BI is limited in the variety of supported libraries, the performance, and the need for a personal gateway. Python is not designed for massive data transforms. Just not the right tool.