Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Yoshihiro, after selecting your tables and clicking the load button you will see the connection settings option pop up.
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