Enterprise Gateway with SQL Server 2008 R2

[ecujak]

We use Dynamics GP 2013 with SQL Server 2008 R2.

Can the gateway be set up with SQL Server 2008 R2?

We also have SQL Server 2012 R2, could we install there and link to the 2008 R2 server?

Does anyone know of options that will enable me to consume (close to real time) onprem SQL Server 2008 R2 data from PowerBI dashboard?

[Greg_Deckler]

According to this article, tabular is supported on SQL Server 2008

https://powerbi.microsoft.com/en-us/blog/working-with-data-models-created-using-sql-server-2008-r2-p...

According to this thread, SQL Server 2008 R2 supports Direct Query

http://community.powerbi.com/t5/Integrations-with-Files-and/Is-Enterprise-Gateway-compatible-with-SQ...

So, my answer would be yes, works.

[u02cm62]

It was for me.  Has to be Direct query then the gateway worked for me as of Sept 2018 version with on premise SQL 2008 R2 with sql auth (Basic auth).