Forum Discussion

SCTDev's avatar
SCTDev
Icon for Advocate I rankAdvocate I
9 years ago
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...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Yes. You are right. You can use either of this ( Direct Query or Import) in a single .pbix file.

SCTDev's avatar
SCTDev
Icon for Advocate I rankAdvocate I
9 years ago

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.

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Yes. You are right. You can use either of this ( Direct Query or Import) in a single .pbix file.