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

Anonymous's avatar
Anonymous
Not applicable
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).

tululum's avatar
tululum
Frequent Visitor
1 year ago

"Desktop you can select Edit Queries -> Data Source Settings -> it will show you import or direct query " - where exactly can you see it?