Forum Discussion

perpor's avatar
perpor
Icon for Helper V rankHelper V
9 years ago
Solved

Verify the use of 'Import' or 'Direct Query'

Good morning   I have some reports working and made in the last month, using Sql server data (db).   I need to verify if in these reports the data are read using 'Import' or 'Direct Query'   ma...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    perpor in the Desktop you can select Edit Queries -> Data Source Settings -> it will show you import or direct query

    If you are in the Service you can click on the elipses next to the dataset -> Settings -> and the gateway should tell you if you are in direct query mode. (If it doesn't, you can just check if you can create a scheduled refresh, you can with import, you can't with direct query).

tushartechlab's avatar
tushartechlab
Icon for Advocate II rankAdvocate II
6 years ago

Morning Fellas,

 

I did come down to this thread this morning, however I was not able to locate that whether the data set that my report was using was in Import or Direct Query mode. Eventually I figured it out. So this is when I am working on Power BI Desktop Version 2.75 (November, 2019).

 

So to check the mode, 

1. Click on "Data" tab int the left pane, which has the 3 buttons (report, data and model)

2. Hover over the fields on the right pane. A tooltip will appear which will tell you the Storage Mode : (Direct Query/Import).

 

Image for reference.

PowerBI Storage Mode

 

And that's it.

 

Let me know if you still not able to locate.

 

Regards,

Tushar

Anonymous's avatar
Anonymous
Not applicable
6 years ago

In the version I'm using (28 Aug 2020, Version: 2.84.861.0 64-bit (August 2020)), you can now be in the Report view (the one that shows the canvas), and point to a table in the Fields pane on the right-hand side and a pop-up will appear. See the associated images.