Forum Discussion

drussellgbc's avatar
drussellgbc
Frequent Visitor
11 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 Salesfo...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 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
11 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
    11 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!

     

  • Akahn's avatar
    Akahn
    Advocate IV
    10 years ago

    So I have a query that takes about 7 minutes to run in SSMS. However, it times out in PowerBI. Any thoughts on why that might be happening?

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      As I mentioned in your other post related to this, you have direct ability to performance tune your source data, I would suggest that you work on reducing the time of execution on the SQL side for your issue.

      • itelligent-i's avatar
        itelligent-i
        Advocate IV
        10 years ago

        Hi  - Wuld be interested to know if you resolved s issue as I've started to get a similar problem.  I've started to get Evaluation time outs on a query from CRM Online.  It's been working fine until yesteday? I cannot work out what has changed?

         

        Thanks