Solved: Import vs direct query

RedDragon · ‎12-07-2020

hi

how do i check which queries are running as direct query and which ones as import?

PhilipTreacy · ‎12-07-2020

Click on the Model icon in PBI to see the table/relationship view. Click the table you are interested in. On the right hand side of the window Under Properties, open the Advaned section. You will see Storage Mode. This will tell you if it is Import or Direct Query.

Phil

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

View solution in original post

PhilipTreacy · ‎12-07-2020

hi @RedDragon

Click on the Model icon in PBI to see the table/relationship view. Click the table you are interested in. On the right hand side of the window Under Properties, open the Advaned section. You will see Storage Mode. This will tell you if it is Import or Direct Query.

Phil

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

Import vs direct query

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly