How can I use DirectQuery for SQL Server ?

[yoshihirok]

How can I use DirectQuery for SQL Server after Option Preview Enable at 2.28.4190.122 of Power BI Desktop ?

I want to check the behavior of DirectQuery for SQL Server at Power BI Desktop.

Environment:

1. Power BI Desktop 2.28.4190.122

2. Options - Perview Features - DirectQuery for SQL Server and Azure SQL Database = Enable.

3. Restart Power BI Desktop after Enabled.

Repro Steps:

1. Select 'Get Data' - 'SQL Server'

2. View 'Import data from a SQL Server database'

There are not DirectQuery Option.

Regards,
Yoshihiro Kawabata

[PowerBIGuy]

Yoshihiro, after selecting your tables and clicking the load button you will see the connection settings option pop up.

[yoshihirok · Accepted solution]

WoW Thank you, PowerBIGuy.

I can do it.
I will start to verify Power BI DirectQuery to TPC-H database on SQL Server 2016 CTP 2.4,

and Azure SQL Database compatibility level 130,

and Azure SQL Data Warehouse, ...

Regards,

Yoshihiro Kawabata