Episode 49 – SPCNA session picks with Liz Sundet

This is episode 49 recorded on May 15th 2018… where John & Jason talk to Liz Sundet, Office Servers & Services MVP from Minnesota, about the upcoming SPCNA Conference in Las Vegas next week and some news related to the upcoming GDPR deadline.

Liz Sundet

Liz is a Microsoft Office Servers and Services MVP and is involved with multiple areas of the business as a consultant for SharePoint and Office 365. Her work includes a variety of aspects from developing strategies to aid in collaboration, identifying best practices for SharePoint and Office 365 to run efficiently and working with multiple teams on identifying needs and areas of improvement. Liz loves a challenge, so everything from a business problem to troubleshooting an error in a system is just another learning opportunity. As a trainer and international speaker, she hopes to inspire others to learn something they can apply to their own work immediately. When she is not working in SharePoint or traveling, you may find her in a variety of activities as diverse as she is: playing music, riding motorcycles, training her dog and even a craft or two. You can follow her on twitter @percusn

Liz’s Picks

Three Must Have SharePoint Workflows with Microsoft Flow Level – Vlad Catrinescu
https://www.sharepointna.com/#!/session/Three%20Must-Have%20SharePoint%20Workflows%20with%20Microsoft%20Flow
5 Simple Ways to Improve Business Productivity with SharePoint, OneDrive, and Microsoft Flow Level: 100 Stephanie Donahue
https://www.sharepointna.com/#!/session/5%20Simple%20ways%20to%20improve%20business%20productivity%20with%20SharePoint,%20OneDrive,%20and%20Microsoft%20Flow
Take a Chance and Hire that  Fine Arts Major Liz Sundet
https://www.sharepointna.com/#!/session/Take%20a%20Chance%20and%20Hire%20that%20Fine%20Arts%20Major

John’s Picks

SharePoint Server 2019: A First Look – Bill Baer & Hani Loza
https://www.sharepointna.com/#!/session/SharePoint%20Server%202019:%20A%20First%20Look
Get the Facts from your SharePoint Site with Analytics, Then Improve It! – Liz Sundet
https://www.sharepointna.com/#!/session/Get%20the%20Facts%20from%20your%20SharePoint%20Site%20with%20Analytics,%20Then%20Improve%20It!
Understanding Office 365 Usage Reporting – Scott Hoag
https://www.sharepointna.com/#!/session/Understanding%20Office%20365%20Usage%20Reporting

Jason’s Picks

Keynote – SharePoint and OneDrive connect your workplace – Jeff Teper, Seth Patton, Omar Shahine, Dan Holme
https://aka.ms/watch/SPVS
Be a SPFx Ninja: with these Performance, Debugging, Logging and Telemetry Tricks! – Andrew Connell
https://www.sharepointna.com/#!/session/Be%20a%20SPFx%20Ninja:%20with%20these%20Performance,%20Debugging,%20Logging%20and%20Telemetry%20Tricks!
Developing SharePoint Framework Web Parts with Power BI Embedding – Ted Pattison
https://www.sharepointna.com/#!/session/Developing%20SharePoint%20Framework%20Web%20Parts%20with%20Power%20BI%20Embedding
Using Flow and Azure Functions to Customize your Site Design – Dave Feldman
https://www.sharepointna.com/#!/session/Using%20Flow%20and%20Azure%20Functions%20to%20Customize%20your%20Site%20Design
Mastering Modern Authentication and Authorization for SharePoint and Office 365 Applications – Eric Shupps
https://www.sharepointna.com/#!/session/Mastering%20Modern%20Authentication%20and%20Authorization%20for%20SharePoint%20and%20Office%20365%20Applications

Episode 46 – Community News and Updates

This is episode 46 recorded on April 17th 2018… where John & Jason talk about a whole bunch of miscellaneous items including GDPR, OneNote, Moving from SSRS SharePoint Integrated Mode, and SharePoint lists in Microsoft Teams.

GDPR White Paper
https://powerbi.microsoft.com/en-us/blog/power-bi-gdpr-whitepaper-is-now-available/
OneNote 2016 being deprecated
https://techcommunity.microsoft.com/t5/Office-365-Blog/The-best-version-of-OneNote-on-Windows/ba-p/183974
Eric Shupps post on issues converting from SSRS Integrated mode to Native mode
https://www.ericshupps.com/sharepoint-2016-ssrs-and-the-native-mode-report-viewer-web-part/
John’s blog series on working with complex SharePoint types in Power BI
https://whitepages.unlimitedviz.com

Jason’s 1 blog in the past couple of months… Viewing SharePoint lists in Microsoft Teams
http://www.sharepointlonghorn.com/using-sharepoint-lists-microsoft-teams/

Shameless self-promotion

SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off

European Collaboration Summit in Mainz, Germany
Use discount code ECS18-Trebinje for a 20 Euro discount
May 28-30, 2018

Episode 41 – The New Power BI Report Server is Here

This is episode 41 recorded on March 15th 2018… where John & Jason talk to  Riccardo Muti, Principal Group Program Manager at Microsoft for Power BI and SQL Server Reporting Services, about the latest Power BI Report Server release & the direction he sees the product going in the future

 

Episode 32 – Size Matters

This is episode 32 recorded on January 11th 2018… where John & Jason talk about scaling Power BI, it’s limits, and how to overcome them.

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 

Size & Scale

What are the limits & why?

Free vs Pro vs Dedicated Capacity storage limits by licensing

App Workspaces vs Office 365 Groups vs Teams confusion

Personal storage limit in Power BI is 10GB per user & per Office 365 Group/App Workspace

Personal storage limit in Power BI is 1GB per model

Maximum size of a single data model limit in Dedicated Capacity is now 10GB
-does NOT go against the user’s personal storage limit

Episode 10 – May I see your license please sir?

Moving a PBIX file to AAS

Load your data model to AAS
https://azure.microsoft.com/en-us/blog/import-power-bi-desktop-files-into-azure-analysis-services/

Kasper’s trick to repoint the PBIX
https://www.kasperonbi.com/change-your-power-bi-report-to-point-to-an-external-ssas-model/

Importing from PBI Desktop to SSAS On Prem – BIInsight
http://biinsight.com/import-power-bi-desktop-model-to-ssas-tabular-2017-using-azure-analysis-services/

Other Stuff to check out

Chris McNulty’s post on Tech Community

SPSEvents site

EDX Power BI Course

John & Jason’s upcoming events

SharePointalooza\North American Collaboration Summit
March 2-3, 2018
SharePointFest DC
March 26-30, 2018
SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off
European Collaboration Summit in Mainz, Germany
May 28-30, 2018

Episode 26 – OnPrem Data Gateway & Power BI Developers news

This is episode 26 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk about the latest updates to the OnPrem Data Gateway, the technical reference implementation for enterprise BI and reporting, and the latest news for Power BI Developers.

News

Technical reference implementation for enterprise BI and reporting
https://azure.microsoft.com/en-us/blog/technical-reference-implementation-for-enterprise-bi-and-reporting/

On-premises data gateway November update is now available
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-update-is-now-available/

  •     The public preview of the long-awaited High Availability support.
  •     The “Additional Logging” setting of the gateway will now include the Mashup engine traces.
  •     The gateway will now automatically fall back to communicating through Azure Service Bus using HTTPS if direct TCP fails.
  •     The gateway now includes the November version of the Mashup engine.

Power BI Developer community November update
https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-november-update/

Azure Resource Manager API

  • Scale up/ down
  • Pause/ start resource
  • Create/ Delete resource
  • Get capacity information
  • Update capacity
  • Get capacity list in a resource group/ subscription

….they will add support for ARM PowerShell soon

Cloud Service Provider purchase channel now available

Visual Options menu and Context menu extension

Injecting custom actions into the options & context menus

Preload API for a better loading experience

Update connection string
https://msdn.microsoft.com/en-us/library/mt814715.aspx

RLS support on AS Azure for pre-defined roles

API 1.9 is now available, adding the ability to open the default browser and navigate to a URL
https://github.com/Microsoft/PowerBI-visuals-tools/blob/master/Changelog.md

How to clone workspaces using the API
https://powerbi.microsoft.com/en-us/blog/duplicate-workspaces-using-the-power-bi-rest-apis-a-step-by-step-tutorial/

Microsoft’s best practices for building custom visuals in Power BI
https://community.powerbi.com/t5/Custom-Visuals-Community-Blog/Security-Developer-Guideline/ba-p/217566

Episode 25 – Power BI Guest Access

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.

 

News

Guest Access now available

https://powerbi.microsoft.com/en-us/blog/power-bi-expands-access-to-intelligence-for-external-guest-users/

  • 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

DigiCert: https://www.digicert.com/

Pluralsight: https://www.pluralsight.com/

RunAs Radio: http://www.runasradio.com/Shows/Show/559

Richard Campbell: https://twitter.com/RichCampbell

Episode 24 – November’s Power BI Desktop update & more

This is episode 24 recorded on November 17th, 2017… where John & Jason talk to about the latest Power BI Desktop update, some new custom visuals, and some community contribution picks.

Power BI Desktop November Feature Summary

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2017-feature-summary/

Stuff John is excited about in November’s Power BI Desktop

  • Rule based conditional formatting in tables
  • Cell alignment for tables
  • Visual ordering in the selection pane (z-order)
  • Lock report objects !!!!!!!
  • ESRI Plus subscription available….
  • Report options for slow data sources in Direct Query (good, but….)
  • New visuals – Image timeline, Social graph, Venn diagram, HTML viewer

Here’s the complete list of November updates:

Reporting

Analytics

Data connectivity – Single Sign-on

Impala connector – support for Windows Authentication
check out Episode 23 for more on SSO

Query editing

Add Column From Examples improvements

Community forum stuff:

Cool infographic that shows what is what in the Power BI space (features w/ license requirements)

 

Power BI Desktop terminology & definitions

New Office 365 launcher showed up

Flow – Calculate running totals

Stacy Simpkins (@sharepointstacy) blog post about migrating SSRS from one SharePoint farm to another

 

Episode 23 – Interview with Dave Feldman

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.

News:
Blog post by Miguel Llopis: Announcing Single Sign-On Support when connecting to data sources from the Power BI Service
https://powerbi.microsoft.com/en-us/blog/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
    • Teradata
    • SAP HANA

Additional data sources will be added:

EOY 2017

    • Impala
    • Oracle
    • SAP BW

H1 2018

    • Spark
    • And others…

Interview notes:
“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

Links:
Shire’s Hub and Link Web Parts: https://github.com/SharePoint/sp-dev-solutions/tree/master/solutions/LinksAndHandlebarsTemplate
Dave’s blog: http://bostonmusicdave.com/
Hyperfish: https://www.hyperfish.com/
tyGraph: https://www.tygraph.com/

Episode 18 – Office 365 Reporting with Anne & Shilpi

John White & Jason Himmelstein talk about Office 365 Reporting with Anne Michels & Shlipi SinhaThis 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.

Show Notes:

Anne’s Ignite News post:

https://techcommunity.microsoft.com/t5/Office-365-Blog/What-s-new-in-Office-365-Usage-Reporting-Ignite-Edition/ba-p/109157

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/


Other topics:

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

Episode 17 – Live from Ignite with Chris Finlan

This is episode 17 recorded on September 26th, 2017 where John & Jason interview Chris Finlan, Program Manager on the SQL Server Reporting Services/Power BI Reporting Server team live at Ignite 2017, and talked at length about the announcements made at Ignite 2017, and about on-premises BI in general.

This interview was streamed live on Facebook, and can be seen below.

Show Notes:

August 2017 Preview of Power BI Report Server

SQL Server Reporting Services 2017

Report Viewer Web Part for SSRS Native Mode