Re: What is Power BI doing when it is "evaluating"...

psmith-nhs-inc · ‎10-27-2017

It seems like it is running the query it is evaluating, then running it again when retrieving records. Which means it is taking twice a long as it should in order to get data.

That would not make any sense, though. So what exactly is happening when Bi is evaluating a query?

Phil

v-yulgu-msft · ‎10-30-2017

Hi @psmith-nhs-inc,

What do you mean "it is taking twice a long"? Do you mean the query is executed twice? Could you provide more detailed information about your scenario? What is your data source? Is there any query reference?

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

psmith-nhs-inc · ‎10-30-2017

I mean it seems like Refresh in Desktop runs every query twice. It looks like it runs it once during the "evaluation" and then again to actually load the records into the database.

My data source n this case is an ODBC connection to a MYSQL database. Under those conditions, what exactly is power BI doing when it is "evaluating" each and every query?