Forum Discussion

drussellgbc's avatar
drussellgbc
Frequent Visitor
10 years ago

Error: The evaluation has timed out.

I finally downloaded Power Bi for Desktop and have been trying to get it connected to a Salesforce database. For the last few years I've been using a middleware to connect Excel PowerPivot to Salesforce so I am excited to get started with Power BI once and for all.

 

I have been setting up the query, but every time I try to 'Apply', I receive an error that the evaluation has timed out. Even after paring back my tables and columns to a fairly small subset.

 

Does anyone know what the problem might be?

 

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    I've seen some mention that the amount of data can be an issue. Have you tried the content pack for Salesforce? Get Data | Services.

     

    Otherwise, send a "frowny face" to support and attach a screen shot of the error. It is the smiley face icon in the upper right in the Service.

    • andre's avatar
      andre
      Memorable Member
      10 years ago

      there are two limitations that make refresh fail:

      1. size of the model - 250MB at the most
      2. refresh time - cannot take more than 30 min
      • drussellgbc's avatar
        drussellgbc
        Frequent Visitor
        10 years ago

        I was able to resolve by starting over and when selecting Salesforce Objects as my data source, NOT selecting the 'Import relationships between Salesforce tables' option. We have a fairly complicated data model so this must have been more than Power BI could deal with.

         

        Thanks for the help!

         

  • Youssef's avatar
    Youssef
    Microsoft Employee
    10 years ago

    Hi drussellgbc, were you able to get this to work for you? Can you update the thread if you are still having issues?

     

     

  • ReportMaster's avatar
    ReportMaster
    Post Partisan
    1 year ago

    I know this reply is very late lol, but were you able to find a solution? I've used the Salesforce connector but I had some issues updating my data too. Maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list: 

     After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

     


    There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.