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.
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?
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.
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).
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 |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |