Forum Discussion

doliver29's avatar
doliver29
New Member
8 years ago

Count, Where and Join

  I am bringing in Objects from Salesforce, for example one object is contacts. I have over 8 mllion contacts in Salesforce and would like to only bring in the contacts that have a ICL Code. I tried...
Need Help
davehus's avatar
davehus
Memorable Member
8 years ago

Hi doliver29, 

 

One you load the data into the query window, you can set a filter on a desired column prior to Close & Load.

 

Is this what you are looking for?

 

Dave

  • doliver29's avatar
    doliver29
    New Member
    8 years ago

    Hi Dave

     

    No when I apply the filter and then do the dataload it still cycles thru the 8 million records before it displays in the filtered columns query so the refresh takes my users 30 minutes before they can access the report. I want the filter to occur before so when it refreshes it will take only a few minutes.

     

    Thanks

    Debbie

    • davehus's avatar
      davehus
      Memorable Member
      8 years ago

      Hi Debbie, 

       

      From what you're describing it sounds like you need to apply a SQL query prior to loading it into the Power Query, but this only works if the data is in a server that you can access. I'm assuming you are using the Salesforce data connector and going by this link, it appears that there are api restrictions which is why you are experiencing the slow load time on the data. 

       

      https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7324208-remove-2000-row-limit-for-salesforce-power-queries

       

      Sorry I can be of any help. 

      • doliver29's avatar
        doliver29
        New Member
        8 years ago

        Thank you I was hoping there was a work around