what does the dataset refresh do to the tables with direct query?

[Anonymous]

Hi all, i need some clarifications on how the dataset refresh done to those tables with direct query.

Scenario:

I have two tables, one is using "import" connectivity and another one is using "directquery" connectivity. My understanding is, we are always going to get the latest data for that table with "directquery" and will only getting the latest data for that table with "import" only if we refresh the dataset in the workspace.

My question is, will the action of refreshing the dataset in the workspace affect the live connectivity of those table with "directquery"? we still going to get the latest data right for that "directquery" table even without refreshing the dataset right? and the act of refreshing the dataset will only affect those table with "import" connectivity. Do enlighten me on this. 

My problem statement is, i need two different kind of refresh rate for different table. "A" table in the database will be live connection (direct query) and "B" table in the excel or other database will be in "import" connection which will be refreshed every once a year. In summary, "A" table is in live connection, "B" table is in scheduled refresh. 

My second problem statement is, i need two different kind of refresh time for different table. "A" table will be refreshed daily, "B" table will be refreshed yearly. I'm thinking of using two different dataset for a report but that one is not doable. 

Do enlighten me on the two different problem statement, is it doable and how to do that? Thank you!

[lbendlin]

will the action of refreshing the dataset in the workspace affect the live connectivity of those table with "directquery"?

Not at all*.  Only Import Mode data sources will be refreshed.

*  As always there's a caveat.  In composite data models (now also sometimes referred to as Mixed Mode) you may have scenarios where a Direct Query connection has a local data model copy.  That local copy may or may not be refreshed.  We haven't been able to get a definitive answer to that question.