Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |