Forum Discussion

PhilippeK's avatar
PhilippeK
Frequent Visitor
4 years ago

Salesforce - Big Object

Dear All,   I have a Power BI project which source is Salesforce. One of my reports is really hard to refresh - I guess it's because of one big Salesforce Object is really big (more than one millio...
Dataflow
PhilippeK's avatar
PhilippeK
Frequent Visitor
4 years ago

Hi collinq,

 

Thanks for your time. I don't know if my question was a real question. What I understand :

 

On Salesforce side : as I'm blind regarding Salesforce limits, it's hard to know what happens on this side : I suppose some other Salesforce export are running during my interfaces, explaining why it works sometimes.

 

On Power BI side : first I use dataflow with a pro license (possible but limited). I was wondering if using a dataflow with a pro license had a link with a poor priority in MS cloud. As I was wondering if the fact to run the dataflow 'on demand' had a better priority than to schedule it.

 

On network side  (firewall, bandwidth) : I don't think that can be a reason. Other 'Salesforce =>Power BI' are running well + sometimes, the interface is running well. Maybe, as it's a big interface, the priority is low so when a lot of people are unning ingterfaces, the interfaces is still waing till it reaches 2 hours.

 

As you see, I don't know more about this point. Maybe the conclusion is that anyway, 'Salesforce to Power BI' interfaces are running well only with small-middle size data. If the data source is big, we must first export data from Salesforce to a datawarehouse, before importing to Power BI.

 

Thanks for your time

 

Philippe

  • collinq's avatar
    collinq
    Super User
    4 years ago

    HI PhilippeK ,

     

    On the Power BI side, I do not believe that there is any prioritization of resources based on the type of license other than a Premium license has dedicated capacity to it.  But, running something to be "on demand" or to be scheduled doesn't change the priority or how it runs.  They both drop into the queue and run when next available.  (That is why when you schedule something or hit "refresh now" it can take a bit before it actually starts.)

     

    As for the speed of Salesforce and Power BI this article has some considerations to think about and confirm in regards to the API's :Connect to Salesforce with Power BI - Power BI | Microsoft Docs

     

    This is from a thread from a few years ago but this thread talks about Salesforce limitations as well...

    Solved: salesforce connectivity - 2000 lines restriction - Microsoft Power BI Community