on premises data gateway - sql server compatibility

[mfpowerbi]

Hello,
what is the minimum version of sql server supported ?

[mfpowerbi]

Thanks

[v-jianboli-msft · Accepted solution]

Hi @mfpowerbi ,

When you use DirectQuery, the gateway supports only SQL Server 2012 SP1 and subsequent versions.

The Minimum requirments of installing on premises gateway:

• .NET Framework 4.7.2 (Gateway release December 2020 and earlier)
• .NET Framework 4.8 (Gateway release February 2021 and later)
• A 64-bit version of Windows 8 or a 64-bit version of Windows Server 2012 R2 with current TLS 1.2 and cipher suites
• 4-GB disk space for performance monitoring logs (in default configuration)

Besides, it's a good general practice to make sure you're using a supported gateway version. We release a new update of the on-premises data gateway every month. Currently, Microsoft actively supports only the last six releases of the on-premises data gateway. If you're experiencing issues with the version you're using, try upgrading to the latest one as your issue may have been resolved in the latest version.

For more details, please refer to:

Manage your data source - SQL - Power BI | Microsoft Learn 

Install an on-premises data gateway | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MichelleTW729]

hi. @v-jianboli-msft 

if our SQL version 2008 and only use import query, can we use on-premises data gateway ? so far didn't see the offical document mention it

Best Regards

MichelleFan