Forum Discussion

RedDragon's avatar
RedDragon
Icon for Helper I rankHelper I
5 years ago
Solved

Import vs direct query

hi

 

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

  • 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

1 Reply

  • 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