Forum Discussion
perpor
Helper V
Helper VVerify 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...
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).
mellieb
Advocate I
Advocate IIs there a way to tell which reports in Power BI web service are using import, direct query, or both without having to go to each semantic model one by one in desktop? Or perhaps there are PBI log files that will provide a complete list of which reporting solutions are using import, direct query, or both in PBI web service?