This is episode 28 recorded on December 14th, 2017… where John & Jason talk about the new SQL Server Management Studio 17.4, a new open source SQL Server CLI, a change to Power BI Premium, and the December updates to Power BI Desktop.
iTunes ratings contest
We are actively trying to get our visibility up for the show and one way to accomplish that is through having ratings on iTunes. To that end, we are asking out listeners to take a moment and rate us on iTunes. Once we hit 10 reviews, hopefully before our Feburary 6th show, we are going to raffle off a $50 Amazon gift card to one of the people who rated us. You will need iTunes to be able to do it, but you can find our page here: https://itunes.apple.com/us/podcast/bifocal-clarifying-business-intelligence/id1266308225
- SSMS 17.4 is now available – https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
- SQL Vulnerability Assessment tool
- Mssql-cli Preview. Open source, requires Python
- Power BI Premium now supports datasets up to 10 GB
- Power BI Desktop December Update
- Q&A in Designer for report creation. This is used at DESIGN time
- Bookmarking now supports cross-highlighting states, more granularity about what the bookmark applies to
- Adding descriptions to field names in the field properties pane
- Scatter plot improvements
- Higher density sampling for at/long on maps
- Responsive slicers – Date, range and horizontal slicers. Works better for mobile too
- Drill filters other visuals – about freakin’ time
- Lots of new custom visuals
- Card browser
- Table heatmap
- Data image
- Power KPI matrix – scorecard like, but not a scorecard
- Text filter – yes!
- Chartaccent linechart/barchart
- New connectors
- Adobe Analytics
- HD Insight interactive Query
- SAP BW
- IBM Netezza now GA
- Most of these are preview – need to be turned on
- Power BI Summit in Dublin – April 24-28 2018
- Presented by PUG and Dynamic Communities
Episode 24 – November’s Power BI Desktop update & more
Episode 15 – Microsoft Ignite 2017 Bonus Episode
This is episode 27 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk to Paul Schaeflein about helping people transform applications using Microsoft Teams, authentication stuff using Azure B2B & Paul quizzes us on how people should be using Power BI.
Paul Schaeflein is a solution architect/developer with more than three decades experience in architecting, designing and developing software solutions. This experience covers a vast range of technologies, languages and industries. Paul is an independent consultant, helping organizations of all sizes with their application development, ALM and SharePoint/Office 365 projects. Paul is a top-rated speaker, having presented at SharePoint Evolutions, the Microsoft SharePoint Conference and TechEd conferences, as well as user groups. In recognition of these community efforts, he is recognized as a Most Valuable Professional (MVP). Paul has a blog at http://www.schaeflein.net/blog, and is active on Twitter as @paulschaeflein. You can also reach him at email@example.com.
Find out more about Paul at https://www.schaeflein.net/speaker-biography/
The webinar for B2B (and Flow): https://www.youtube.com/watch?v=AIImcUZyP7U
SharePoint Conference NA: https://www.sharepointna.com use discount code SCHAEFLEIN
Power BI Report Server episode with Chris Finlan
This is episode 25 recorded on November 24th, 2017… Black Friday… or as we call it, Analytics Friday… where John & Jason talk about Power BI Guest Access using Azure B2B and some tips, tricks & community shout outs.
Guest Access now available
- AAD B2B with Power BI is available starting today. Read the documentation and try inviting an external user now!
- For more information and a step-by-step guide to distributing BI content with Power BI and Azure AD B2B read this whitepaper. Also visit Azure documentation for more information on Azure AD B2B.
-Power Query Tip – Cached data remembers its source – even after you change it in the Query Editor. You need to make sure it’s totally refreshed.
-Facebook Query has totally changed: https://whitepages.unlimitedviz.com/2017/11/facebook-location-tracking-power-bi/
Community shout outs
RunAs Radio: http://www.runasradio.com/Shows/Show/559
Richard Campbell: https://twitter.com/RichCampbell
This is episode 23 recorded on November 7th, 2017… where John & Jason talk to about the new single-sign on methods for the Power BI service and an interview with Dave Feldman, Microsoft MVP from Shire Pharmaceuticals.
Blog post by Miguel Llopis: Announcing Single Sign-On Support when connecting to data sources from the Power BI Service
“… it is now possible to use Single Sign-On, leveraging Kerberos, when connecting to certain data sources using DirectQuery mode from Power BI.”
Config link: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-kerberos-for-sso-pbi-to-on-premises-data/
Support for Single Sign-On is available for the following data sources as of today:
- SQL Server
- SAP HANA
Additional data sources will be added:
“Using BI to make intelligent business decisions”TyGraph, HyperFish & onPrem IIS Logs to do proper analysis around what was being used during the planning phases of the integration between Shire & BaxaltaThe analysis fueled Dave’s migration decisionsLooking into the future to multi-geo decision planning for SharePoint Online
Shire’s Hub and Link Web Parts: https://github.com/SharePoint/sp-dev-solutions/tree/master/solutions/LinksAndHandlebarsTemplate
Dave’s blog: http://bostonmusicdave.com/
This is episode 22 recorded on November 2nd, 2017… where John & Jason talk to about the brand new release of Power BI Report Server, PowerApps custom visuals, & Power BI Licensing.
Power BI Report Server new version
PowerApps Custom Visual
PowerApp on a report, not just a tile
PowerApp visual can be filtered
Another post about licensing
PBI Report Theme Generators
Online – https://powerbi.tips/tools/report-theme-generator-v3/
Excel Based – https://hopeinternational.box.com/s/gd57sn7djq0bs6p2miut62extxdgucwn
Office them to PBI theme converter – https://1drv.ms/u/s!AkRyAgtzGndznMl3VKm1K8YJp0wsHQ
“Everything you wanted to know” Workshops
John speaking at ESPC
SPFest Chicago (use code WHITE for a discount)
SPFest DC (use code WHITE for a discount)
SharePoint Conference North America (use code JASEHIMM for a discount)< /p>
This is episode 20 recorded on October 3rd, 2017 where John & Jason talk to John’s colleagues, Ed Senez & Dean Swann from tyGraph to debrief on Microsoft Ignite from a real world Business Intelligence perspective. We discuss tyGraph, which allows organizations to take Office 365 reporting to a whole new level, and finally about their new podcast, tyGraph Moneyball, which focuses in on the why of using reporting and analytics.
tyGraph YouTube channel
tyGraph Moneyball podcast
Dean’s Ignite session – “Mining Yammer Data for Gold with Power BI”
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.
- 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)
- Hard to find – Search for “Microsoft Power ….”
- New Desktop this month
- SSRS 2017 now generally available
- SSAS 2017 now generally available
- SSIS 2017 Now Generally available
- Where is PowerPivot for SharePoint 2017????
This is episode 18 recorded at Microsoft Ignite on September 27th, 2017… where John & Jason talk to Anne Michels & Shilpi Sinha from the Office 365 Product Team about Office 365 Reporting.
Anne’s Ignite News post:
Office 365 Adoption Content Pack –> 22 reports
2 new usage reporting for Microsoft Teams released at Ignite
The Office 365 Adoption Content Pack in Power BI to go GA at the beginning of 2018 and will be rebranded to Office 365 Usage Analytics
Reports Reader Role
Available as of Sept 27th
Graph Reporting APIs go GA
Preview post: https://blogs.office.com/en-us/2017/03/31/whats-new-in-office-365-administration-public-preview-of-microsoft-graph-reporting-apis/
SharePoint & OneDrive Admin Center updates
To get early access to the preview version of the new SharePoint admin center, please register at https://aka.ms/joinAdminPreview
Office 365 Usage Analytics will be GDPR compliant
Where to find info about Office 365 Reporting information online:
Office 365 Message Center: https://portal.office.com/adminportal/home#/MessageCenter
Tech Community: https://techcommunity.microsoft.com/t5/Office-365-Blog/bg-p/Office365Blog
Office 365 Roadmap: https://www.office365.com/roadmap
Support Center: https://support.office.com/en-us/article/Activity-Reports-in-the-Office-365-admin-center-0d6dfb17-8582-4172-a9a9-aed798150263
Anne & Shilpi’s Ignite sessions
BRK2039: Understand how your users are using Office 365: Introducing Advanced usage reporting tools
Via MyIgnite: https://myignite.microsoft.com/sessions/53327
YoutTube: Understand how your users are using Office 365: Introducing Advanced usage reporting tools
BRK2011: Understand how your users are using Office 365: What’s new in usage reporting
Via MyIgnite: https://myignite.microsoft.com/sessions/53258
YoutTube: Understand how your users are using Office 365: What’s new in usage reporting – BRK2011
BRK1009: Manage Office 365 more effectively: What’s new in Office 365 administration
Via MyIgnite: https://myignite.microsoft.com/sessions/53331
YouTube: Manage Office 365 more effectively: What’s new in Office 365 administration – BRK1009