Forum Discussion

sahgir123's avatar
sahgir123
Frequent Visitor
2 months ago
Solved

Power BI Data load , Refresh from Salesforce is Taking Too Long

Hi Community, I'm currently working on a Power BI project where the data source is Salesforce. The dataset currently consists of only 3 Salesforce objects, with a total of approximately 5 million (5...
Data Protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-achippa's avatar
    v-achippa
    2 months ago

    Hi sahgir123,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Kagiyama_yutaka and parry2k for the prompt response.

     

    Since you have already implemented incremental refresh and partitioning, this does not looks like a power bi model issue. The refresh time is more likely related to retrieving the data from salesforce through the salesforce API.

    If the refresh is still taking a long time even for the latest partition, please check whether the delay is happening while retrieving the data from salesforce. If so, there is limited optimization available from the power bi side. Use a staging database or fabric lakehouse or warehouse as the refresh source for larger salesforce datasets.

     

    Thanks and regards,

    Anjan Kumar Chippa