Episode 19 – Dummy proofing for Executives

This is episode 19 recorded on October 12th, 2017… where John & Jason talk to about the news including a new version & way of deploying Power BI Desktop and what’s interesting in the release of SQL Server 2017.

Show Notes:

• PBI Desktop now available in the Windows Store
  • The Modern client is there too
  • Settings get wiped out, but there’s a way to prevent that (John’s blog post)
    • https://whitepages.unlimitedviz.com/2017/10/get-power-bi-desktop-from-the-microsoft-store/ 
  • Hard to find – Search for “Microsoft Power ….”
• New Desktop this month
  • https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2017-feature-summary/
  • Bookmarks and spotlights.
  • Let you save “versions” of a report
  • Service, mobile and gateway were updated correspondingly
• SSRS 2017 now generally available
  • https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/10/02/sql-server-2017-reporting-services-now-generally-available/
  • REST API
  • Report Viewer code and web part
  • Report comments
• SSAS 2017 now generally available
  • https://docs.microsoft.com/en-us/sql/analysis-services/what-s-new-in-sql-server-analysis-services-2017
  • Supports the modern Get Data experience
  • “1400” compatibility
  • Bigger, better, faster
• SSIS 2017 Now Generally available
  • https://docs.microsoft.com/en-us/sql/integration-services/what-s-new-in-integration-services-in-sql-server-2017
  • Lift and shift to ADF
  • https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview
  • Scale Out
  • Visual Studio 2017
• Where is PowerPivot for SharePoint 2017????