Forum Discussion
Trouble with loading Salesforce backup data through Phyton script
Run your data operations outside of Power Query/Power BI, save the results as CSV or Parquet, and then ingest them in Power BI.
We decided that based on the operations that we do on the data that this would be the best solution. So to build the table that we want outside of PowerBI because it gave to much difficulties when we tried it in PowerBI itself.
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.