Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

0
saileekumawat

Queries run twice

Submitted by Advocate I on ‎05-16-2017 01:35 PM

Hi, 

 

I have observed that every query that we write in power BI runs twice, even from power BI service. This does not sound good for bigger dashboards with more data. 

 

The max execution time for any query is 120 minutes. However, as the query run twice, it leaves user with 60 minutes. 

Status: Delivered
See more ideas labeled with:
10 Comments (10 New)
Comments
saileekumawat
Advocate I
Advocate I
‎05-16-2017 10:25 AM

Hi, 

 

I have a question related to import data setting with Azure SQL dw as a source. 

 

I have muliple queries in my data set , and what i have observred is all these queries run twice before completion and hence some times they fail due to timeout..

Is this is by behavior ? Is there is any way to make it run only once ? And why does it run two times? 

 

Thanks,

Sailee

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎05-18-2017 01:13 AM

@saileekumawat

 

Could you please provide a simple sample to us? And from which tool or something else do you see that every query runs twice?

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎05-18-2017 01:13 AM
Status changed to: Needs Info
 
saileekumawat
Advocate I
Advocate I
‎05-18-2017 07:00 AM

Hi, 

Hi,

I am checking from azure portal monitoring option as from sql server. Here is an example. In my dashboard, I have 10 queries. When I resfresh data set from power BI portal and check in azure monitoring as well as SQL server I can see queries running. However, After all queries are executed once, I can see they all re run with different QIDs. 

 

See below.. The query text is exactly same for first two queries and start time is different. 

 

 

Same Query Running twice.PNG

 

Thanks,

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎05-20-2017 02:32 AM

@saileekumawat

 

It seems that I cannot repro the same issue on my side. I tried to refresh both on Desktop and Service, but I only get a QID for each action as below.

 

Queries run twice_1.jpg

 

I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).
If issue is resolved, you can share the solution here later to help others who have the same problem.

 

Alerts are not creating. It stays forever loading..gif

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎05-31-2017 10:07 PM
Status changed to: Delivered
 
hannahshachar
New Member
‎08-07-2017 06:32 AM

Same problem.  It is avery severe issue.  We are already pulling a lot of data, this is making the load of this tool on our database twice as bad.  It happens when we write a query (not when we click on a table and go from there).   

Anonymous
Not applicable
‎10-30-2017 02:22 PM

Same problem here! PowerBi executes three times my query, I'm using odbc connection to a redshift database, did someone find the solution?

taja
New Member
‎05-23-2018 03:29 AM

I have the same problem when calling an API via Web.Contents(). I checked with Fiddler: every query is executed twice with the exact same parameters.

Anonymous
Not applicable
‎06-01-2018 04:47 AM

I also have the same problem. I've tried both for MySQL and Snowflake and the same result. All queries run twice.

Idea Statuses