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: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

hannahshachar

All queries run twice in the database when opening a dashboard.

Submitted by on ‎08-07-2017 06:47 AM

All queries run twice in the database when opening a dashboard.

This cause double load on the database, which is already struggling to output all of the data.

This is a very severe issue and needs to be resolved.  

Note, when clicking on a database visually, this does not occur, but when writing a query that the dashboard is based on, the query runs twice.

Status: Needs Info
See more ideas labeled with:
8 Comments (8 New)
Comments
v-haibl-msft
Employee
Employee
‎08-08-2017 02:51 AM

@hannahshachar

 

Could you please provide some more details about it?

What is your data source in this scenario (Import or DirectQuery)?

What is the exact step about writing a query that the dashboard is based on?

From where you observe the query run twice?

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎08-08-2017 02:51 AM
Status changed to: Needs Info
 
hannahshachar
New Member
‎08-08-2017 05:38 AM

Data source : I am connecting to Vertica by ODBC It’s a query The dashboard is based on the query data (power bi desktop) As I am an administrator of the DB, I have a monitor where I watch what queries are running in real time. There I can see that 2 queries occur instad of 1. I want to make it clear that this happens whenever someone is using the dashboards or analyzing data using PowerBI and not just in one or two specific dashboards. Thanks

 

power BI.png

v-haibl-msft
Employee
Employee
‎08-08-2017 11:56 PM

@hannahshachar

 

So you are using the Import mode, right? Do you mean that if one user open the dashboard in Power BI Service, all queries will run twice in the db? Could you please post a screenshot of the monitor which shows the queries run twice? At the same time could you please help collect the fiddler traces when the user open the dasbhoard? And share the .saz file to me through online file service like OneDrive.

 

Fiddler.jpg

 

Best Regards,
Herbert

hannahshachar
New Member
‎08-09-2017 02:41 AM

We are using Desktop, so I want to make sure that the Fiddler and .saz file are relevant in the case of Desktop?  I attached the monitor that picked up the two simultaneous queries.  That occurred when I opened the dashboard (also attached screenshot of the dashboard).  

 

 

double query.PNG

 

 

dashboard.PNG

 

 

 

 

hannahshachar
New Member
‎08-09-2017 02:44 AM

Strangely, the table that stores logs of queries shows that it actually sent the query 4 times. 

 

query in queryHist.PNG

v-haibl-msft
Employee
Employee
‎08-22-2017 02:53 AM

@hannahshachar

 

Fiddler and .saz file are also needed in the case of Desktop.

 

Best Regards,
Herbert

ThierryG
Regular Visitor
‎02-15-2022 01:44 PM

I'm experiencing similar issue when accessing DENODO by ODBC / by DENODO conector from Power BI desktop. I'm working in import mode. The issue appears after the creation of at least one reference view on a base view (with "enable load" disabled). The objective is to decouple the base view (only used to connect to the data source) to derived views (where I apply the transformations). Taking into consideration this configuration I should not exepect more than one data load.

Actually I have another reference view on the first reference view, thus creating 3 data layers.

Level 3 ("enable load" enabled) references to level 2 ("enable load" disabled) references to level 1 ("enable load" disabled).

Having 3 levels of layers the total number of data loads is still twice.

Idea Statuses