SSRS and Excel use cases
In certain reporting scenarios, a paginated or 'classic' report with a fully configured page and report layout defined in a Visual Studio SSRS project is appropriate. Additionally, for organizations which can only deploy BI on-premises or if certain BI content such as highly sensitive reports must remain on-premises, Power BI Report Server provides a single on-premises solution and portal to include both traditional SSRS reports and optionally Power BI reports as well.
Similarly, although Power BI Desktop supports many of the most commonly used Excel features in addition to many other advantages, the free-form flexibility of spreadsheet formulas for complex 'what-if' scenario modeling across many variables and granular ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access