June 4, 2019 at 2:55 pm
Dear SQLServerCentral experts,
I have a question related with being able to use on premisses PowerBI without have to migrated the hole strcture to SQL Server 2017.
We are a Business Intelligence solution that used the following Tools:
SSIS; SSRS; SQL Server; SSAS and Sharepoint
I have read that for us to use on premisses PowerBI, this could only be done by migrating the infrastructure to 2017, meaning all :
SSIS; SSRS; SQL Server; SSAS and Sharepoint
But lately I spoke with the developers on the Project which told that we can actually migrate just the SSRS to PBI and Keep all the remain Tools (SSIS; SQL Server; SSAS and Sharepoint) in 2016 version.
If that is the case, I would prefer that Approach as I don't see to mcuh added value related with migrating the hole infrastructure.
Can you please help clarify?
Thank you
June 4, 2019 at 4:14 pm
IF you have SQL Enterprise AND software assurance you can leave the components at 2016 level and install an instance of 2017 PBIRS on the same licensed server and that will work and be covered from a licensing point of view.
IF you do not have both Enterprise and SA then you will need a cloud license (5k+ a month) which enables you to install PBIRS on a on prem server covered for a number of cores based on your cloud license - if this is the case then its probably better to install this on a new server and not on the one that you are paying a separate license for.
I do have PBIRS latest version installed on production servers with SQL 2016 (latest CU/SP) and no issues.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply