DirectQuery and invisible elements

[Tropped]

Hi!

I have some tables with different queries using DirectQuery in the same page. The thing is, some will be invisible until someone goes to some bookmark.

My question is: if the table is invisible, is the query done? (that is, is the query done when the table is made visible, or as soon as you change to that page?)

Thanks!

[Tropped]

First of all, thanks for answering.

Yeah, I meant the table visual. It can be a table, chart, etc. What I'm asking is, if I set the visual as invisible (through the selection pane), will it load the data, even if it isn't showing?

[Anonymous]

Are you refering to the visual table on Report page? When you say table is invisible, do you mean the table is empty? or the table is removed from the report page?

In DirectQuery mode, Power BI will send query request to the source data server when a page is refreshed. The empty visual table means the query result is empty. 

[Anonymous]

HI @Tropped,

For directquery mode, power bi not direct import or copy data to power bi, so data panel will been disabled.

power bi will generate queries to execute on database side and receive result and format them as table. (it similar as t-sql result table, not real generated and only used display the result)

Please take a look at following links to know about this mode:

DirectQuery, Live Connection or Import Data? Tough Decision!

Use DirectQuery in Power BI Desktop

Regards,

Xiaoxin Sheng