Clarifying Business Intelligence, Power BI, Office 365, and more
John White recently published a couple of posts to help clarify the licensing requirements around the Power BI web part for SharePoint. The first, “What License is Needed to Use the Power BI Web Part?” deals with the nuances of using Power BI Pro vs the Premium licensing model.
The second, “Power BI Embedded is not for Embedding Power BI Reports” discusses the Premium model in Power BI Embedded, and why it’s not appropriate for use with SharePoint.
Recorded August 17th, 2017
This is episode 10 recorded on August 17th, 2017 where we talk about the new Power BI licensing model & Microsoft Ignite.
Show notes:
Audit and govern how data is accessed and used
Recorded August 3rd, 2017
In this episode, John and Jason look talk about about SQL Server 2017 RC2, PowerApps, and updates to the Power BI service.
Show notes:
Recorded July 14, 2017
In this episode, John and Jason look specifically the July 2017 updates to Power BI in the Desktop, the service, and to the On-Premises Data Gateway. Additionally, we talk about the fact that in September, we’ll be recording in front of a live audience at the Microsoft Ignite conference in Orlando!
Topics include:
What’s in the new Power BI Desktop Client
– Table & matrix visual
– Custom visuals store
New On-Premises Data Gateway in July
– Keeps the mashup (Power Query) engine in sync with Desktop update
No changes to the new Premium licensing SKU yet for Power BI
Power BI Reporting Server licensing questions
Microsoft Workplace Analytics goes General Availability
Power BI web part is GA, but it still says”Preview” in the service. What’s up with that?
Recorded June 13, 2017
After a long hiatus, Jason and John are back with the podcast! The format has changed, and now it’s audio-only (for the moment at least) and we’re trying to keep it down to a consumable 30 minutes.
In this re-launching episode both Jason and John were in Johannesburg for the Share conference, and took the opportunity to discuss all of the important announcements coming out of the Microsoft Data Analytics summit, which was happening half a world away in Seattle.
Topics discussed include:
– Changes to the Power BI Free and Pro SKU
– Announcement of additional tiers of Premium Pricing for Power BI
– General Availability of the Power BI Web Part for SHarePoint Online
– Changes to the Power BI Embedded platform
– Power BI Reporting Server
– Power Apps and Flow integration with Power BI
Recorded August 11, 2016
Power BI has been getting a lot of attention recently, but it represents only the cloud platform of Microsoft’s BI strategy. As clearly announced last fall, the other main platform, deployed on premises, is SQL Server Reporting Services (SSRS). The release of SQL Server 2016 represents a major leap forward for SSRS.
Join Jason and John as they welcome guest Riccardo Muti, from the SSRS team at Microsoft to discuss the past, present and future of this venerable BI tool.
News Items
New On Premises Data Gateway
Customizable dashboard for Power BI mobile
Data Driven alerts in the Power BI Service
Row Level Security now in the Desktop
Analyze in Excel now connects to on prem SSAS data
Power BI Dataset API improvements
PBI Embedded and Publish to web are now Generally Available
Announcing the release of the Azure Usage and Billing Portal
Tips
Use FieldValuesAsText when reporting on SharePoint data
Recorded May 19, 2016
In this episode, we were fortunate enough to have Kasper De Jonge as our guest. Kasper is Senior Program Manager on the Analysis Services team, and has been with the tabular data model since its inception.
We covered a fair bit of ground, including topics like:
– What’s the difference between classic cubes and the new tabular model
– Why is the tabular model “everywhere” these days?
– What do the new terms mean?
– How does SharePoint and PowerPivot for SharePoint fit into the new landscape?
– Where does claims authentication fit into the picture?
– When is it, or is it not appropriate to use Power Query
And several other topics.
We invite you to check out the recording of the show for the details.
News
SQL Server 2016 Launches on June 1
Standard Edition now supports Tabular models
Power BI Storage increases to 1 GB per model
Power BI Q&A works with Enterprise Gateway data sources (tabular model only)
Working with SharePoint Lists in Power BI and OData – Marc Anderson
PBI Gateways supports UPN mapping
Drilldown has moved to the explore menu in Power BI
Tips and Tricks
Username() function in DAX only works when RLS is configured
You can’t rename fields in PBI Visuals, but you can create calculated measures and columns
Recorded April 28, 2016
The excitement for Power BI continues to build. The driving force behind this is its ease of use, the from zero to insight speed. It’s easy to overlook the fact that Power BI also has a strong development story too. Join Jason and John as they welcome special guest Ted Pattison of Critical Path consulting to discuss the developer landscape in Power BI.
News
Analyze Power BI models in Excel now available
Row level security has arrived in Power BI
SQL Server 2016 RC3 is available
PBI Mobile App now supports SSRS Mobile reports
tyGraph is in the Power BI Desktop!!!!
Notes
Developer tools:
PBI Developers site
Tips and Tricks
Recorded March 24, 2016
SharePoint 2016 is now generally available!!!
Jason and John welcome guests Kay Unkroth and Gregory Appel from Microsoft to discuss the BI changes in SharePoint 2016. Kay is a senior Product Manager responsible for BI intergration in SharePoint, and Greg is a senior PM in charge of Excel Online.
The big topic discussed is the fact that Excel Services have moved over to the Office Online Server. Our guests tackle the questions and repercussions of this, as well as many other topics including Microsoft’s renewed focus on SQL Server Reporting Services.
NEWS
SharePoint 2016 Hits the street, but Office Online Server not there yet
Microsoft Data Summit
Excel now connects to PBI Models – uses MSOLAP
Row level security coming
Sand dance visual
New KPI visual in the service. First “official” new visual since launch
PBI Integration with Sway
PBI Mobile now supports SSRS Mobile reports
Tips and Tricks
Custom visuals gallery for Power BI
John’s what you need post for BI in SharePoint
Recorded February 25, 2016
After the monthly News Update, Tips & Tricks, and What’s New in Power BI, John & Jason explain the Microsoft BI stack & it’s related technologies. They roll up their sleeves to dive into where each product can\should\will be best utilized in the business world of today.
Notes
Gartner names Microsoft Leader in BI
Tips and Tricks
Use the right account with Enterprise Gateway
Survey Tool with Power BI
What’s New In Power BI
Anonymous publishing of Power BI Content – Live Shark demo
Power BI Publisher for Microsoft Excel
Enterprise Gateway