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).

saleti's avatar
saleti
Frequent Visitor
6 years ago

Not seeing "Data" option in the left pane. do you know why?

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

Hey saleti 

 

I guess this is because all of your datasets may be in "Direct Query" mode. Generally when you use "Direct Query" in data sources or "Live Connection" in analysis services sources, the data tab is not shown. It is possible that all your data sets are in direct / live query mode so it is nto visible. Try adding  a simple (sys.tables) data set in import mode into the power bi desktop and see if it starts becoming visible. Or take a new report, add one source in import mode and then add the others in direct query mode and it should start showing.

 

This is a problem that a lot of people have run into.

 

Let me know if that works. 

 

Regards,

Tushar