Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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!

 

ameng_0-1660726684110.png

 

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors