Episode 48 – Power BI Desktop May Updates

This is episode 48 recorded on May 8th 2018… where John & Jason talk about Guy in a Cube’s new video, and walk through the new features of the May 2018 Power BI Desktop which includes the much anticipated incremental refresh.

Guy in a Cube CDSA – Common Data Service for Analytics (CDS-A) and Power BI – an Introduction
https://youtu.be/1vQ0HLNZ06A

Excel Gets custom visuals “soon”
https://powerbi.microsoft.com/en-us/blog/excel-announces-new-data-visualization-capabilities-with-power-bi-custom-visuals/

New PBI Desktop for May
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/

Reporting
• Conditional formatting by a different field
• Advanced slicer syncing
• Log axis improvements
• Data label options for funnel chart
• Set line stroke width to zero

Analytics
• Measure drillthrough

Power BI Premium
• Incremental refresh (preview)

Custom visuals
• Collage by CloudScope
• Chinese Color Map

Data connectivity
• New “From Web” connector – By example data extraction (preview)
• Common Data Service for Apps connector (beta)
• Azure KustoDB connector (beta)
• Google BigQuery and Azure HDInsight Spark connectors now generally available
• Adobe Analytics connector update – Support for multiple domain logins (preview)
• Visual Studio Team Services connector update – Analytics views support
• OLE DB connector update – Support for alternate Windows credentials
• SAP BW DirectQuery connector update – Improved technical name support

Data preparation
• Improvements to Add Column From Examples

Episode 47 – Excel Update with Olaf Hubel

This is episode 47 recorded on April 30th 2018… where John & Jason interview Olaf Hubel, Senior Program Manager at Microsoft on the Excel Engineering team.

Excel User Voice
https://excel.uservoice.com/

Excel Blog
https://techcommunity.microsoft.com/t5/Excel-Blog/bg-p/ExcelBlog

Excel Community
https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat

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 45 – All about the new CDSA & CDS-A

This is episode 45 recorded on April 12th, 2018… where John & Jason take a deep dive on the announcements about the new Common Data Service for Analytics (CDSA) and the new Common Data Service for Apps (CDS-A).

CDSA (Common Data Service for Analytics) and CDS-A (Common Data Service for Apps) are NOT built on CDS

CDSA (Applications) is the logical successor to CDS. And to XRM – All about entities.

Business Apps spring update document – https://aka.ms/businessappsreleasenotes

Announcement from the Power BI team
https://powerbi.microsoft.com/en-us/blog/coming-soon-to-power-bi-common-data-service-for-analytics/

Today in the browser you can bring in some data as is (CSV, XLS) & connect to data models.

With CDS-A you get Power Query
– ETL (Power Query) in the cloud
– It’s a Data Lake (warehouses and marts) that you can connect to
– Also includes pre-defined schemas and connectors (specifically  Dynamics)
– Connect data models to it

Power BI Desktop today combines ETL and data modeling. CDS-A can help separate those concerns.

Analytics apps (the successor to solution templates) will build on CDS-A

Power BI video on this page – https://dynamics.microsoft.com/en-us/release/spring-2018-release/

Once loaded, data is referred to as “Data Pools”

Sign up to receive updates on the CDS for Analytics capability

Get notified when Power BI Insights apps become available

Shameless self-promotion

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

European Collaboration Summit in Mainz, Germany
May 28-30, 2018

Episode 44 – Power BI Desktop, Gateway, & Developer updates for April 2018

This is episode 44 recorded on April 9th 2018… where John & Jason talk about the Developer Update & the Gateway Update for March and the Power BI Desktop update for April.

Power BI Desktop – April Update

Power BI team blog article

Reporting

Analytics

YAML

Custom visuals

Data connectivity

 

John & Jason’s upcoming events

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 43 – The Power BI Community with Chuck Sterling

This is episode 43 recorded on March 8th 2018… where John & Jason talk to Charles Sterling who runs the MVP Program for the PowerApps, Flow, and Power BI about his experience working at Microsoft, his view of the Power BI Community in the larger Power*s world, and non-NDA stuff about MVP Summit.

Who is Chuck Sterling?

Charles Sterling joined Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as the Visual Studio community program manager and just recently moved to the Power BI team to continue his community passion and looking after the Power BI influencers and MVPs.

Links:

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 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