DirectQuery option disabled while connecting to Azure SQL Datawarehouse from Power BI Desktop.

[deeptigeorge]

Hi Everyone,

Please point out the possible reasons of; DirectQuery option disabled while connecting to Azure SQL Datawarehouse from Power BI Desktop.

[Anonymous · Accepted solution]

@deeptigeorge,

Do you connect to other data sources in your current PBIX file? If so, the directquery mode will be disabled,

In DirectQuery mode, all data must come from a single database of a single data source. 

Regards,
Lydia