Episode 42 – The Power BI Embedded Show

Embedded

This is episode 42 recorded on March 23rd 2018 where John & Jason talk to Megan Assarrane, Senior Product Marketing Manager at Microsoft for Power BI Embedded. We dispel some misunderstandings about embedded licensing, discuss the retirement of the old Workspace Collections product and walk through the awesomeness that is the new Power BI Embedded service.

Show Links:

Power BI Embedded Webpage: https://azure.microsoft.com/en-us/services/power-bi-embedded/
What’s new for Power BI Embedded: https://azure.microsoft.com/en-us/updates/?product=power-bi-embedded
Hands-on embedding tool: https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html
Migration documentation: https://docs.microsoft.com/en-us/azure/power-bi-embedded/migrate-from-power-bi-workspace-collections

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

 

Power BI Reporting on a Multi-value SharePoint Column

Hey all – John here. One of the things that we get asked frequently is how to report on SharePoint data. The answer is of course, “well, it’s easy, but it depends”.

In the spirit of clearing up the “it depends” part, I’m in the process of writing a series of articles that walks through the nuances of the various SharePoint complex data types. The first one shows some options for reporting on multi-value SharePoint columns, and includes tricks that pertain to more sources than just SharePoint.

You can find the post here. Enjoy!

Episode 30 – New Years News

This is episode 30 recorded in January 1st 2018… where John & Jason talk about the news from the past few weeks in Power BI, Office 365, and Azure.

Show Notes:

On-premises data gateway December update

-includes a number of bug fixes and improvements to previously released features
-matches the Mashup Engine that was released as a part of the Power BI Desktop December update

Sync members from O365 Modern group to a mail-enabled security group

-This is one of the issues that we run into because Power BI is NOT a part of Office 365
-The solution that Adam shows is a viable, one time solution but does not solve the longer term issue
-This can be scripted to run daily, but it is duplicating groups at that point which will ultimately cause problems
-We love Adam Saxton & Patrick LeBlank and recommend people subscribe to the YouTube Channel GuyInACube
-We don’t actually recommend you do this…

The Reddit Solution Template

-Point solution for Reddit
-Similar solutions exist for Twitter, Facebook, & Bing News
-What are Solution Templates anyway?
-Who is this for? Social Media Managers… that use Reddit
Server aliases for Azure Analysis Services

-Aliasing is always a good idea
-migration situations
-easier to remember
-obfuscates actual server information
-allows the use of Azure Traffic Manager
-Users can connect to the server from Power BI Desktop (in addition to other client tools) using the link:// format

Azure Analysis Services integration with Azure Diagnostic Logs

-Various scenarios are supported, including the following:
-Auditing
-Monitoring of server health
-Derivation of usage metrics
-Understanding which user groups are using which datasets and when
-Detection of long-running or problematic queries
-Detection of users experiencing errors
-Consume diagnostic logs in Power BI
-give you a text file that contains an M expression, which can be pasted into a blank query in Power BI Desktop
-The expression contains the current Log Analytics query and consumes from the Log Analytics REST API

Episode 21 – Miguel Llopis, PM for On-Prem Data Gateway and Power Query

This is episode 21 recorded at Microsoft Ignite on September 26th, 2017. This is the last of our Ignite interviews. We had the privilege of sitting down at length with Miguel Llopis, Senior Microsoft Program Manager responsible for Power Query, the On-Premises Data Gateway, and much more.

Miguel has been with Power BI since before there was a Power BI. Listen in – there’s a lot here!

Episode 20 – Ignite recap and Office 365 Reporting with the tyGraph Team

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.

Show Notes:

tyGraph

tyGraph YouTube channel

tyGraph Moneyball podcast

Dean’s Ignite session – “Mining Yammer Data for Gold with Power BI”

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

 

Episode 16 – Live from Ignite with Sirui Sun

This is episode 16 recorded on September 13th, 2017 where John & Jason interview Sirui Sun, Program Manager on the Power BI team live at Ignite 2017, and talked at length about licensing.

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

Show Notes:

Power BI Premium

Power BI Embedded capacity-based SKUs coming to Azure

Understanding the Power BI Capacity Based SKUs

Install and use apps in Power BI

Episode 15 – Microsoft Ignite 2017 Bonus Episode

Treb Gatte joins us to talk about Microsoft Ignite 2017
Treb Gatte, MBA, MCTS, Business Solutions MVP

This is episode 15 recorded on September 13th, 2017 where John & Jason talk about the September 2017 updates to Power BI Desktop, interview Treb Gatte, and share our session picks for Microsoft Ignite 2017.

Show Notes:

Treb Gatte

Tumble Road – Power BI Training and Services

Microsoft Ignite 2017 Picks

In anticipation of Microsoft Ignite 2017, we all decided to pick a few sessions from Ignite. To avail it being overwhelming, we each took a category. Given the length, out picks are divided into three different blog posts, links below.

Jason’s Picks

John’s Picks

Treb’s Picks

Jason’s Session Picks for Microsoft Ignite 2017

The Orange County Convention Center

During Episode 15 of the podcast Jason made his session picks for Microsoft Ignite 2017. Here are his picks:

Office 365, SharePoint, & OneDrive:

Accelerate your digital transformation with SharePoint and OneDrive

https://myignite.microsoft.com/sessions/53867

Dan Holme, Jeff Teper, Omar Shahine

Session Code: BRK2184

Learn how new and upcoming SharePoint and OneDrive innovations empower people and organizations to share with confidence, transform business processes, engage employees, and harness collective knowledge from anywhere, on virtually any device. During this must-see session, Microsoft Corporate Vice President Jeff Teper, Office, SharePoint and OneDrive, shares the latest innovations and roadmap for content management and collaboration as well as how customers are creating more connected workplaces leveraging Office 365, Windows, and Microsoft Azure.

Support data residency in global organizations with multi-geo support for SharePoint and OneDrive

https://myignite.microsoft.com/sessions/53873

Sesha Mani, Bill Baer

Session Code: BRK3236

One of the key strengths of SharePoint and Microsoft OneDrive are their inherent resilience and ubiquity: a well planned architecture ensures your data resides in multiple locations, providing resilience and the ability to serve data to partners, customers, and employees wherever they happen to be. In this session we introduce new multi-geo capabilities that allow you to meet your data sovereignty needs and ensure compliance with residency requirements.

 

Learn from MVPs: Panel discussion on all things SharePoint and OneDrive

https://myignite.microsoft.com/sessions/53843

Alistair Pugin, Spencer Harbar, Laura Rogers, Wictor Wilen

Session Code: BRK2247

SharePoint MVPs talk about Microsoft SharePoint and OneDrive across the board, be it within Office 365, in Microsoft Azure, on-premises and certainly hybrid. Via a panel Q&A format, these MVP experts expose how online and hybrid improvements increase both deployment scenarios and value. This session is designed to help ITIs and ITDMs find the right cloud formula to deploy based on practical business and technical considerations. This is a must-not-miss session for any IT pro!

Azure:

Datacenter transformation – a roadmap for platforms, processes, and people

https://myignite.microsoft.com/sessions/55827

Jeffrey Snover

Session Code: BRK3378

Cloud adoption opens a new opportunity for IT pros to play a strategic role in the future of the business by ensuring hybrid cloud assets are secure and well managed. To effectively manage cloud born assets, it’s key to understand how application architectures are evolving through innovations in the cloud platform. Get some advice for how IT practitioners can not only stay relevant, but thrive today while getting ahead of a rapidly changing ecosystem. Join Jeffrey Snover, Technical Fellow, to understand how you can innovate and drive business results faster using Microsoft Azure.

Azure Compute: New features and roadmap

https://myignite.microsoft.com/sessions/54926

Corey Sanders

Session Code: BRK3085

A can’t-miss DEMO HEAVY session for everyone working with or considering their strategy for the cloud! We take a look at some of the newest features and upcoming capabilities in the Azure Compute platform. We show some new sizes, new experiences, and new integration technology available during Microsoft Ignite or coming soon across VMs, Azure Service Fabric, Azure Container Service, Azure Functions, and more.

Azure security and management for hybrid environments

https://myignite.microsoft.com/sessions/54789

Jeremy Winter

Session Code: BRK2405

As organizations continue their digital transformation to the cloud, they are faced with the need to secure and manage resources across hybrid environment. Join this session to learn how Azure security and management services help you address these challenges without any secondary tools, and increase agility for your business. Jeremy Winter, Partner Director in Azure Security and Operations Management, will share the new and upcoming technologies to secure and manage your workloads wherever they are.

Identity:

What’s new in Azure Active Directory Domain Services

https://myignite.microsoft.com/sessions/55292

Mahesh Unnikrishnan

Session Code: BRK3295

Azure AD Domain Services enables you to effectively administer your Azure virtual machines by joining them to a fully managed Active Directory domain in Microsoft Azure. You do not have to worry about deploying, managing, patching, or monitoring domain controllers and can focus on running your workloads in Azure. Users can sign in using their Active Directory credentials and can access resources seamlessly. Azure AD Domain Services provides Group Policy, an easy, familiar way to apply and enforce security baselines on all of your Azure virtual machines. See what’s new in Azure AD Domain Services and explore how you can leverage this service to secure your Azure virtual machines.

Modernize your customer identity management with Azure Active Directory B2C

https://myignite.microsoft.com/sessions/53340

Saeed Akhter

Session Code: BRK2276

Getting your customers to seamlessly sign-up or sign-in to an application is paramount to its success. Achieving this at scale while following constantly evolving security practices is hard. Come and learn about Azure AD B2C, an enterprise-grade customer identity and access management service, and how it allows you to easily secure your consumer-facing (or citizen-facing) web and mobile applications. No matter where your users live, reach them with customizable user experiences that allow your users to sign-up/sign-in with social accounts such as Facebook or Google, or new accounts in the application.

Understanding hybrid identity, authentication, and authorization with Microsoft Azure Stack

https://myignite.microsoft.com/sessions/53276

Shriram Natarajan

Session Code: BRK4011

Join us for a discussion on hybrid identity and learn how apps can authenticate consistently with Microsoft Azure and Azure Stack. We cover APIs and methods to connect to an Azure instance regardless of whose datacenter it is running on!

Bonus pick:

PowerShell Unplugged with Jeffrey Snover and Don Jones

https://myignite.microsoft.com/sessions/54867

Jeffrey Snover, Don Jones

Session Code: BRK3128

Join Jeffrey Snover, the inventor of PowerShell, and Don Jones for their annual PowerShell update. During this talk, you will learn about the latest and coolest PowerShell features to help you automate and manage the hybrid cloud. The focus of this year’s talk is on the PowerShell community, and how it is embracing open-source and transformative change and producing awesome tools.