Forum Discussion

AdeJong's avatar
AdeJong
New Member
1 year ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Run your data operations outside of Power Query/Power BI, save the results as CSV or Parquet, and then ingest them in Power BI.

lbendlin's avatar
lbendlin
Super User
1 year ago

Why Python?  Why not place the CSV files on a SharePoint and ingest natively into Power BI?

  • AdeJong's avatar
    AdeJong
    New Member
    1 year ago

    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.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      Run your data operations outside of Power Query/Power BI, save the results as CSV or Parquet, and then ingest them in Power BI.

      • AdeJong's avatar
        AdeJong
        New Member
        1 year ago

        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