cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

Long time "Evaluating..." for no apparent reason during data import. Can it be made faster?

I am connecting to a SQL database through a Stored Procedure. As far as I know, there is no intelligence that needs to be applied during the query. It should simply ask SQL to run the sproc, and gather the results.

 

However, for some reason, PBI stays a good two minutes or more, simply "evaluating". What is it doing exactly? Is there any way this can be accelerated, so that it gets to the date faster?

 

I've read about folding, but since this is running an sproc, I don't think it applies.

 

Thanks in advance for any pointers.

31 REPLIES 31
Resolver II
Resolver II

he seguido los pasos indicados y me ha funcionado sin problemas:

- Borrar cache de Power BI

- Anular niveles de privacidad para  este reporte.

New Member

And the correct answer is?

Advocate II
Advocate II

Sharing my success in resolving this issue.  One of my PBIX dataset has many queries some of them are merge or reference queries.  Occasionaly I run into the issue of Report Refresh getting stuck in the initial "Evaluating" step, for all of my queries/tables, and this is stuck permanantly until I cancel the refresh.  Went through following solution ideas, and finally fixed it with the last one.

 

- Clear PBI Desktop cache: does not help.
- Refresh all queries in preview: also stuck.
- Clean cache then refresh all in preview: also stuck.

- Disable privacy check for the report: Success. Able to get past evaluation step immediately and refresh normally.

 

Reference article: https://blog.crossjoin.co.uk/2017/05/24/data-privacy-settings-in-power-bipower-query-part-1-performa...

In addition to what @chaz2jerry  has listed, you might want to check other data source locations in the file for any broken links.

 

You can find them under "Data source settings" (current file)

 

If any of those paths are broken, Power BI will hang with message "Evaluating...", even if your accessing a competely new location.

 

You can test this by opening a new blank Power BI and trying to access the same location.

 

To fix, check every path/source to make sure none are broken and have correct permissions etc.

 

I've reported the issue to Microsoft, as I don't think Power BI should just hang under any of the below scenarios, but rather report something back to the user to help resolve.

 

-Clear PBI Desktop cache: might help.

-Refresh all queries in preview: might help.

-Clean cache then refresh all in preview: might help.

-Disable privacy check for the report: might help

-Check all your path locations under "Data source settings": a broken path can lead to PBI hanging

 

I've also posted this as an Idea referencing this forum.

 

 

Hi @chaz2jerry ,

 

best answer, you have saved lot of waitingtime of my live 🙂

 

Thank you!

 

BR,

Sven

Frequent Visitor

Mine takes hours.

 

Does anyone know if this also affects the scheduled refresh? Mine keeps timing out but comments in this thread are suggesting that the evaluating process might now happen on that end, so Im starting to think I might have another problem somewhere.

 

Thanks

Frequent Visitor

Hello,

I am facing the exact same issue. Despite the fact that we use Power Bi Premium for Incremental refresh, it seems Power Bi is downloading the entire Datatable during 'Evaluating' when any changes are made in the queries. This makes making changes to queries very tiring and difficult when handling large databases. 

 

In a nutshell, this eliminates the usefullness of Incremental refresh fundamentally. Can you kindly confirm why PowerBI talkes ages at evaluating and what is done to ensure that Power BI desktop doesnt end up downloading entire database tables in PowerBI Desktop?

 

Regards,

Nouman Qaiser

Frequent Visitor

Issue affecting me too.

 

Raised a ticket with PBI helpdesk, will keep you posted on response.

@Autonomousone  Did you ever get a response from the power bi team ?

Sorry for the late response. 

 

So after i raised the ticket, I came back over the weekend after shutting down my computer find that it was working correctly. I then recieved a call from MS and they advised to clear power BI cache and to then restart. 

 

Though I wasn't able to replicate this at that time that time, I ran into the same evaluation problem a few hours ago and after following the PBI team's advice - it appeared to have resolved the issue.

 

I followed the the steps in this link and just restarted my computer. 

https://www.c-sharpcorner.com/blogs/how-to-clear-cache-of-power-bi-desktop

 

Fingers crossed this works for you. 

 

 

 

Anonymous
Not applicable

 1+ for this, has it been logged as a bug?

Advocate I
Advocate I

This issue appears to persist with the September 2018 release. I have to kill the refresh at least one time in order to pass the "Evaluating" phase.

Found a workaround:

1.  Go to Edit Queries

2.  Refresh Preview on every table.

3.  Close and Apply

4.  Refresh Data

This worked for me!!! Thank you!

Frequent Visitor

This just started happening to me after upgrading to their August 2018 release.  So **bleep** annoying.  

 

**edit**

I just downgraded to June 2018 release to get past this issue.

I just started having issue of this today with a couple reports that requires join tables within PBI.... these are actually mission critical reports... anybody have any idea if MS is aware of this probleM?

the refresh has been fine for the last couple months we've been using thsi...

The AUGUST release has killed performance for me. Going to try the July version and compare...

It's official. The refresh complets in the July release but never completes in the August release!!!

 

Had one of our DEv staff upgrade to the August and September releases and solutions that have never had a probloem now timeout on dataload or sit in Evaluating mode.

 

Something is BROKEN !

Microsoft PLEASE Fix !

Same behaviour. Where could we found old versions ? 

Is microsoft team aware about the issue ? 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors