Will SSRS be extinct soon, and PowerBI the new model?Recommended hardware configuration Analysis and...
Show about 5 teens who all have elemental powers and turn into different humanoid creatures
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
If an area is covered in both Ball Bearings and Caltrops, does the creature need to move at half speed or quarter speed to avoid both their effects?
Why do climate experts from the UN/IPCC never mention Grand Solar Minimum?
Why don't hotels offer ≥ 1 kitchen that must be booked?
Why is Shelob considered evil?
Why does Python copy numpy arrays where the length of the dimensions are the same?
If I can't win, but can stop my opponent from winning, is the game drawn?
Why did Shae (falsely) implicate Sansa?
Why is Bernie Sanders maximum accepted donation on actblue 5600$?
Taking an academic pseudonym?
Sing Baby Shark
Why does the current not skip resistors R3 and R5 when R6 and R4 have no resistance?
Found a major flaw in paper from home university – to which I would like to return
Proposal for leaving the job
Run a command that requires sudo after a time has passed
Is the "hot network questions" element on Stack Overflow a dark pattern?
Why do most space probes survive for far longer than they were designed for?
Bitcoin automatically diverted to bech32 address
Python 3.7 UltimateBruteforcer
Should corporate security training be tailored based on a users' job role?
"Cheaper by the dozen" phrase origin?
Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once
How bad is a Computer Science course that doesn't teach Design Patterns?
Will SSRS be extinct soon, and PowerBI the new model?
Recommended hardware configuration Analysis and Reporting ServicesBest Possible Solution for Reporting Mirroring or Replication?Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012MS SQL installation on Windows 10 Home edition failsSSRS 2016 Connect to SQL Server with Force Encryption EnabledWhat options are there for security on shared data sources for SSRS?How to definitively clear away database before restoring from new version of backup fileCan you run two WSFC instances on two servers where each node is the primary for a different availability group?Where to start for DW/BI project?
I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft will eventually try to deprecate SSRS? Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
sql-server ssrs business-intelligence sql-server-2017 powerbi
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
add a comment |
I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft will eventually try to deprecate SSRS? Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
sql-server ssrs business-intelligence sql-server-2017 powerbi
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
add a comment |
I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft will eventually try to deprecate SSRS? Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
sql-server ssrs business-intelligence sql-server-2017 powerbi
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft will eventually try to deprecate SSRS? Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
sql-server ssrs business-intelligence sql-server-2017 powerbi
sql-server ssrs business-intelligence sql-server-2017 powerbi
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
edited Jan 5 '18 at 10:07
a_horse_with_no_name
39.9k776112
39.9k776112
asked Sep 15 '17 at 3:18
user129291
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
About the separate installer for SSRS, here's a good reason: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/ In summary, SSRS, and PowerBI Report Server has similar features hence it might be beneficial from the developer's perspective to group them accordingly (just a hunch, I am not a Microsoft employee, so I do not have visibility on this).
Does this mean Microsoft will eventually try to deprecate SSRS?
No one knows what the future holds, so we don't know if Microsoft will deprecate SSRS in the foreseeable future. In my opinion, SSRS is a paginated report solution as compared to PowerBI which is more of a Dashboard/Analytics tool; The two still caters different types of users. So No, at this point, I do not see Microsoft deprecating SSRS.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
Look into the use case of PowerBI. As far as my experience can say if a user is repeatedly generating reports with different parameters you can consider a PowerBI Report with a bunch of slicers instead. You can also consider it if an SSRS Report is comparing historical values. But the real deal with PowerBI (Excel 2016 or PowerQUery in Excel 2013) is its Self Service nature. It allows a user to connect to common data sources and perform different transformations with minimal coding, and the output report can repeatedly be executed whenever an update has happened on the data sources.
Edit:
It has been a year and right now the Paginated Reports capability is included in PowerBI (Both service and report server). From a technology perspective RDL files will not be deprecated. But from a solutions perspective the only thing that prevents Microsoft from deprecating SSRS is the licensing. SSRS comes free with SQL Server Express, while the Paginated Reports capability of PowerBI comes with SQL Server Enterprise Edition with Software Assurance (Through PowerBI Report Server) and PowerBI Premium (P1 and above).
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
add a comment |
Does this mean Microsoft will eventually try to deprecate SSRS?
Ref:
https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/07/19/sql-server-2017-reporting-services-release-candidate-now-available/
No.
We moved Reporting Services installation from the SQL Server installer
to a separate installer. This is a packaging change, not a product
change; access to SQL Server Reporting Services is still included with
your SQL Server license. The new installation process keeps our
packages lean and enables customers to deploy and update Reporting
Services with zero impact on your SQL Server deployments and
databases.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
If you need PowerBI you should start using it but not thinking SSRS being deprecated.
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f186029%2fwill-ssrs-be-extinct-soon-and-powerbi-the-new-model%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
About the separate installer for SSRS, here's a good reason: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/ In summary, SSRS, and PowerBI Report Server has similar features hence it might be beneficial from the developer's perspective to group them accordingly (just a hunch, I am not a Microsoft employee, so I do not have visibility on this).
Does this mean Microsoft will eventually try to deprecate SSRS?
No one knows what the future holds, so we don't know if Microsoft will deprecate SSRS in the foreseeable future. In my opinion, SSRS is a paginated report solution as compared to PowerBI which is more of a Dashboard/Analytics tool; The two still caters different types of users. So No, at this point, I do not see Microsoft deprecating SSRS.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
Look into the use case of PowerBI. As far as my experience can say if a user is repeatedly generating reports with different parameters you can consider a PowerBI Report with a bunch of slicers instead. You can also consider it if an SSRS Report is comparing historical values. But the real deal with PowerBI (Excel 2016 or PowerQUery in Excel 2013) is its Self Service nature. It allows a user to connect to common data sources and perform different transformations with minimal coding, and the output report can repeatedly be executed whenever an update has happened on the data sources.
Edit:
It has been a year and right now the Paginated Reports capability is included in PowerBI (Both service and report server). From a technology perspective RDL files will not be deprecated. But from a solutions perspective the only thing that prevents Microsoft from deprecating SSRS is the licensing. SSRS comes free with SQL Server Express, while the Paginated Reports capability of PowerBI comes with SQL Server Enterprise Edition with Software Assurance (Through PowerBI Report Server) and PowerBI Premium (P1 and above).
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
add a comment |
About the separate installer for SSRS, here's a good reason: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/ In summary, SSRS, and PowerBI Report Server has similar features hence it might be beneficial from the developer's perspective to group them accordingly (just a hunch, I am not a Microsoft employee, so I do not have visibility on this).
Does this mean Microsoft will eventually try to deprecate SSRS?
No one knows what the future holds, so we don't know if Microsoft will deprecate SSRS in the foreseeable future. In my opinion, SSRS is a paginated report solution as compared to PowerBI which is more of a Dashboard/Analytics tool; The two still caters different types of users. So No, at this point, I do not see Microsoft deprecating SSRS.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
Look into the use case of PowerBI. As far as my experience can say if a user is repeatedly generating reports with different parameters you can consider a PowerBI Report with a bunch of slicers instead. You can also consider it if an SSRS Report is comparing historical values. But the real deal with PowerBI (Excel 2016 or PowerQUery in Excel 2013) is its Self Service nature. It allows a user to connect to common data sources and perform different transformations with minimal coding, and the output report can repeatedly be executed whenever an update has happened on the data sources.
Edit:
It has been a year and right now the Paginated Reports capability is included in PowerBI (Both service and report server). From a technology perspective RDL files will not be deprecated. But from a solutions perspective the only thing that prevents Microsoft from deprecating SSRS is the licensing. SSRS comes free with SQL Server Express, while the Paginated Reports capability of PowerBI comes with SQL Server Enterprise Edition with Software Assurance (Through PowerBI Report Server) and PowerBI Premium (P1 and above).
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
add a comment |
About the separate installer for SSRS, here's a good reason: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/ In summary, SSRS, and PowerBI Report Server has similar features hence it might be beneficial from the developer's perspective to group them accordingly (just a hunch, I am not a Microsoft employee, so I do not have visibility on this).
Does this mean Microsoft will eventually try to deprecate SSRS?
No one knows what the future holds, so we don't know if Microsoft will deprecate SSRS in the foreseeable future. In my opinion, SSRS is a paginated report solution as compared to PowerBI which is more of a Dashboard/Analytics tool; The two still caters different types of users. So No, at this point, I do not see Microsoft deprecating SSRS.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
Look into the use case of PowerBI. As far as my experience can say if a user is repeatedly generating reports with different parameters you can consider a PowerBI Report with a bunch of slicers instead. You can also consider it if an SSRS Report is comparing historical values. But the real deal with PowerBI (Excel 2016 or PowerQUery in Excel 2013) is its Self Service nature. It allows a user to connect to common data sources and perform different transformations with minimal coding, and the output report can repeatedly be executed whenever an update has happened on the data sources.
Edit:
It has been a year and right now the Paginated Reports capability is included in PowerBI (Both service and report server). From a technology perspective RDL files will not be deprecated. But from a solutions perspective the only thing that prevents Microsoft from deprecating SSRS is the licensing. SSRS comes free with SQL Server Express, while the Paginated Reports capability of PowerBI comes with SQL Server Enterprise Edition with Software Assurance (Through PowerBI Report Server) and PowerBI Premium (P1 and above).
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
About the separate installer for SSRS, here's a good reason: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/ In summary, SSRS, and PowerBI Report Server has similar features hence it might be beneficial from the developer's perspective to group them accordingly (just a hunch, I am not a Microsoft employee, so I do not have visibility on this).
Does this mean Microsoft will eventually try to deprecate SSRS?
No one knows what the future holds, so we don't know if Microsoft will deprecate SSRS in the foreseeable future. In my opinion, SSRS is a paginated report solution as compared to PowerBI which is more of a Dashboard/Analytics tool; The two still caters different types of users. So No, at this point, I do not see Microsoft deprecating SSRS.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
Look into the use case of PowerBI. As far as my experience can say if a user is repeatedly generating reports with different parameters you can consider a PowerBI Report with a bunch of slicers instead. You can also consider it if an SSRS Report is comparing historical values. But the real deal with PowerBI (Excel 2016 or PowerQUery in Excel 2013) is its Self Service nature. It allows a user to connect to common data sources and perform different transformations with minimal coding, and the output report can repeatedly be executed whenever an update has happened on the data sources.
Edit:
It has been a year and right now the Paginated Reports capability is included in PowerBI (Both service and report server). From a technology perspective RDL files will not be deprecated. But from a solutions perspective the only thing that prevents Microsoft from deprecating SSRS is the licensing. SSRS comes free with SQL Server Express, while the Paginated Reports capability of PowerBI comes with SQL Server Enterprise Edition with Software Assurance (Through PowerBI Report Server) and PowerBI Premium (P1 and above).
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
edited 5 hours ago
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
answered Jan 4 '18 at 12:06
RoyceBautistaRoyceBautista
12113
12113
add a comment |
add a comment |
Does this mean Microsoft will eventually try to deprecate SSRS?
Ref:
https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/07/19/sql-server-2017-reporting-services-release-candidate-now-available/
No.
We moved Reporting Services installation from the SQL Server installer
to a separate installer. This is a packaging change, not a product
change; access to SQL Server Reporting Services is still included with
your SQL Server license. The new installation process keeps our
packages lean and enables customers to deploy and update Reporting
Services with zero impact on your SQL Server deployments and
databases.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
If you need PowerBI you should start using it but not thinking SSRS being deprecated.
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
add a comment |
Does this mean Microsoft will eventually try to deprecate SSRS?
Ref:
https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/07/19/sql-server-2017-reporting-services-release-candidate-now-available/
No.
We moved Reporting Services installation from the SQL Server installer
to a separate installer. This is a packaging change, not a product
change; access to SQL Server Reporting Services is still included with
your SQL Server license. The new installation process keeps our
packages lean and enables customers to deploy and update Reporting
Services with zero impact on your SQL Server deployments and
databases.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
If you need PowerBI you should start using it but not thinking SSRS being deprecated.
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
add a comment |
Does this mean Microsoft will eventually try to deprecate SSRS?
Ref:
https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/07/19/sql-server-2017-reporting-services-release-candidate-now-available/
No.
We moved Reporting Services installation from the SQL Server installer
to a separate installer. This is a packaging change, not a product
change; access to SQL Server Reporting Services is still included with
your SQL Server license. The new installation process keeps our
packages lean and enables customers to deploy and update Reporting
Services with zero impact on your SQL Server deployments and
databases.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
If you need PowerBI you should start using it but not thinking SSRS being deprecated.
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
Does this mean Microsoft will eventually try to deprecate SSRS?
Ref:
https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/07/19/sql-server-2017-reporting-services-release-candidate-now-available/
No.
We moved Reporting Services installation from the SQL Server installer
to a separate installer. This is a packaging change, not a product
change; access to SQL Server Reporting Services is still included with
your SQL Server license. The new installation process keeps our
packages lean and enables customers to deploy and update Reporting
Services with zero impact on your SQL Server deployments and
databases.
Should our team try to build new reports in PowerBI and transition the previous SSRS reports?
If you need PowerBI you should start using it but not thinking SSRS being deprecated.
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
answered Sep 15 '17 at 4:05
SqlWorldWideSqlWorldWide
8,19021335
8,19021335
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f186029%2fwill-ssrs-be-extinct-soon-and-powerbi-the-new-model%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
