Re: Enterprise Gateway with SQL Server 2008 R2

ecujak · ‎11-21-2016

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 · ‎11-21-2016

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

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

So, my answer would be yes, works.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎09-18-2018

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).

Enterprise Gateway with SQL Server 2008 R2