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

     

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
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

 

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
2 months ago

Hi sahgir123,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have  provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    1 month ago

    Hi @sahgir123,

     

    We wanted to kindly follow up to check if the solution I have  provided for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa