Forum Discussion
Solved
DirectQuery option disabled to SQL Server database
I have Personal Gateway installed and connected to the database I want to use. How do I activate the DirectQuery option within PBI Desktop when trying to Get Data? Is there a setting somewhere t...
Yes. You are right. You can use either of this ( Direct Query or Import) in a single .pbix file.
Each pbix file can only use one Data Connectivity mode. So if you had previously uploaded data via "Import", you will not be able to use "DirectQuery" within that same report. Solution is to open up a brand new report; as you will see, the DirectQuery option will be selectable.