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.
My option is dimmed and therefore unselectable. Likely because I already used the Import feature for previous data and it won't let me select data using both methods. Of course, I am not certain of this.
Yes. You are right. You can use either of this ( Direct Query or Import) in a single .pbix file.