Can I use on-premise SQL Server in DirectQuery

[Anonymous]

Hi,

I have a project that requires me to use DirectQuery connection and I am aware that this connection has data source limitations.

Can I use on-premise SQL Server to connect with Power BI through DirectQuery?

[amitchandak · Accepted solution]

@Anonymous , I used the SQL server express on my machine for it(Direct Query). I think you should be able to use sql server. Unless it is old version not supported.

example 1: https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885

example 2: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA