Category: Uncategorized

Episode 75 – PASS Summit News & Dataflows

Thisis episode 75 recorded on November 9th, 2018 where John & Jason talk aboutthe news coming out of PASS Summit and break down the introduction of Dataflows.

Show Notes

Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop

https://powerbi.microsoft.com/en-us/blog/power-bi-delivers-dataflows-enterprise-reporting-and-major-updates-to-power-bi-desktop/

  • Dataflows expand self-service data prep in Power BI
  • SQL Server Reporting Services technology now in Power BI
  • Power BI Desktop November Update
    • Will cover in detail on a future show once this drops

Introducing: Power BI data prep with dataflows

https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/

  • Self-service data prep for big data in Power BI 
  • Advanced Analytics and AI with Azure
  • Support for the Common Data Model
    • Getting started with self-service data prep
    • Ingesting large amounts of data with Incremental Refresh
    • Building complex ETL projects with Linked entities
  • Gaining further insights with Computed entities
    • Connecting datasets to your data

Public Preview of Paginated Reports in Power BI Premium Now Available

https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available

Power BI Paginated Reports also available in Power BI Mobile Apps(preview)

https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-also-available-in-power-bi-mobile-apps-preview

Paginated report metrics and dataflow metrics now available in Premium Capacity Metrics app

https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/

Premium Capacity Metrics app – query metrics histogram now available

https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-query-metrics-histogram-now-available/

 

Episode 74 – Interview with Amir Netz

This is episode 74 recorded on September 24th, 2018 where John & Jason interview Amir Netz, Technical Fellow and Chief Architect of Microsoft BI offerings at Microsoft, about all things Power BI.

Show Notes

About Amir
https://news.microsoft.com/stories/people/amir-netz.html

Elly Gotz’s story
http://fortune.com/2018/11/01/pittsburgh-synagogue-shooting-holocaust/?fbclid=IwAR2SdrRuhIWYVRhH8-vsEmHVfhQ-VLmP7udG0wHsHHVuMpdmKkKn0NovK9s

Chris Finlan’s blog post: “Export to PowerPoint is now generally available and looking ahead at what’s coming next”
https://powerbi.microsoft.com/en-us/blog/export-to-powerpoint-is-now-generally-available-and-looking-ahead-at-what-s-coming-next/

Last week’s interview with Chris Finlan
https://www.bifocal.show/2018/10/30/episode-73-interview-with-chris-finlan/

Episode 73 – Interview with Chris Finlan

This is episode 73 recorded on October 22nd, 2018 where John & Jason talk to Chris Finlan, Senior Program Manager for Power BI at Microsoft, about the Power BI Report Server, Paginated Report in the cloud via Power BI, and much more.

Show Notes

Power BI Report Server release timing update

Chris Finlan on Twitter

PASS Summit (Focus Groups)

Episode 65 – Meetup with Reza Rad

This is episode 65 recorded on September 11th, 2018 where John & Jason talk to Microsoft MVP and Regional Director Reza Rad about Reza’s Power BI background, and our joint meetup at Microsoft Ignite.

Reza Rad is an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for seven continues years (from 2011 till now) for his dedication in Microsoft BI. Reza is author of Power BI from Rookie to Rock Star and some other books. He is training and consulting on Microsoft BI and Data Analytics technologies.

Show Notes:

Meetup at Ignite with John, Jason & Reza
https://myignite.techcommunity.microsoft.com/sessions/66510

RADACAD
radacad.com

Power BI Helper
http://radacad.com/power-bi-helper

Upcoming Events

Microsoft Ignite 9/24-9/28 
https://www.microsoft.com/en-us/ignite

European SharePoint Conference 11/26-11/29
https://www.sharepointeurope.com/

SharePointFest Chicago
https://sharepointfest.com/Chicago/

SPTechCon Boston – February 10 – 13, 2019
https://www.sptechcon.com/west 

North American Collaboration Summit – March 14 – 16, 2019
http://www.collabsummit.org/

SPFest DC – April 29 – May 3, 2019
https://sharepointfest.com/Chicago/

SharePoint Conference 2019 – May 21 – 23, 2019
http://www.sharepointna.com

Eurpoean Collaboration Summit – May 27 – 29, 2019
http://www.collabsummit.eu



Episode 59 – Interview with Will Thompson

This is episode 59 recorded on July 31st, 2018 where John & Jason talk about SharePoint Saturday NYC, sessions for Microsoft Ignite, and interview Will Thompson from the Power BI Desktop Team at Microsoft.

Show Notes:

Intro to Power BI Desktop – Will’s session from Business Application Summit 2018

Power BI Desktop July 2018 Release

Power BI and the Future for Modern and Enterprise BI (Business Application Summit 2018)

 

Episode 58 – SharePoint BI and July 2018 Power BI Desktop Release

This is episode 58 recorded on July 25th 2018 where John & Jason talk about Business Application Summit after-the-fact, The Road Ahead for Power BI & SharePoint blog post, and do a deep dive on the Power BI Desktop update for July.

Show Notes:

Power BI and SharePoint – the road ahead

Power BI Desktop July 2018 Release

Episode 55 – The Power of the Cloud

This is episode 55 recorded on June 28th 2018 where John & Jason talk about a few recent bugs and service interruptions, the recent Power of the Cloud conference, PowerApps, Flow, and some recent improvements to the usability of the On Premises Data Gateway

 

Show Notes

Organizational Account Authentication has stopped working for Microsoft Graph in Power BI
https://community.powerbi.com/t5/Issues/Error-getting-OData-from-Microsoft-Graph-Access-to-the-resource/

Easier configuration of Gateway data sets in the Power BI service:
https://powerbi.microsoft.com/en-us/blog/easier-set-up-of-datasets-in-power-bi/

Power of the Cloud show –
http://powerofthecloud.net

IWMentor PowerApps training
https://www.iwmentor.com/courses/powerapps-introduction

Coming events

Business Applications Summit 7/22-7/24 – https://www.microsoft.com/en-us/businessapplicationssummit

SPSNYC 7/28 – http://www.spsevents.org/city/nyc

SPFest Seattle 8/20-8/24 – https://sharepointfest.com/Seattle/

SPTechCon 8/26-8/29 – http://www.sptechcon.com/

Microsoft Ignite 9/24-9/28 – https://www.microsoft.com/en-us/ignite

European SharePoint Conference 11/26-11/29 – https://www.sharepointeurope.com/

Thrive Conference  Dec 4-5 2018 – http://www.thriveconf.com

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

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!