Episode 99 – Interview with Abram Jackson and Tyler Lenig from the Microsoft Graph Data Connect Team

This is episode 99 where John & Jason talk to Abram Jackson & Tyler Lenig, Program Managers from the Graph Data Connect Team,  about the release of Microsoft  Graph Data Connect & how it can be used with Power BI.

Show Notes

Microsoft Graph Data Connect Overview

Using Microsoft Graph Data Connect with PowerBI dataflows

We are now on Spotify!

BIFocal Facebook page hits 200 likes

Dataflows vs Data Flows

User Voice Picks

John – Time Zone Conversion Accounting for Daylight Savings Time

We need a way to display data in our local timezone accounting for daylight savings time. The data source stores the dates in UTC but we need reports to show local time. A native and easy way to do this in PowerBI would be a huge help. There are many blog posts and help articles floating around with solutions people have attempted but it’s a simple issue that so many users would benefit from having solved centrally by PowerBI itself. Please consider!

Jason – Paginated reports – please make it available in Pro as well as Premium

Paginated reports – please make it available in Pro as well as Premium .. thank you

Episode 97 – Interview with Matthew Roche

This is episode 97 recorded on March 21st, 2019 where John & Jason talk to the SQL All Father himself, Matthew Roche, Senior Program Manager on the Power BI CAT team, about Dataflows, sword play, and much more.

Show Notes

Matthew’s blog – BI Polar

Matthew on Twitter – SQLAllFather

Power BI Dataflows Go Live

Academy of European Medieval Martial Arts

Deadliest Art: A documentary on Historical European Martial Arts

User Voice Picks

John – Allow fonts to be customized

Jason – One single schedule task for sequential refresh of both Dataflows + Dataset

Episode 96 – April 2019 Power BI Desktop Update

This is episode 96 recorded on April 15th, 2019 where John & Jason talk about latest update to Power BI Desktop the including features like Drillthrough across reports, Filter pane improvements, & Dataflows connector now being generally available, plus a breakdown of some other news AND User Voice Picks!

News

Privacy Levels for Cloud Data Sources

Paginated Reports now supported in Apps in Power BI

Governance settings for Power BI cache refreshes from Azure Analysis Services

Desktop Drop

Reporting

Analytics

Modeling

Visualizations

Data connectivity

Data preparation

Other

User Voice Picks

John

Power BI Desktop should use the currently logged in account credentials for dataflow connections

When connecting to a dataflow in Power BI Desktop, the connection is cached like all other connections. Each connection persists the relevant tokens for their sources. However, when persisting a SQL connection, each database is cached separately, so different credentials can be used with different databases.

However, dataflows will only store the last connection to a dataflow, which makes connecting to dataflows in multiple tenants an arduous process of changing the data connect options.

Also confusing is the fact that the account switcher control is unrelated to the dataflow credentials, leading to situations where publish shows one set of workspaces, but the dataflow connector shows another.

Having the account switcher credentials tied to the dataflow connection credentials would solve both of these problems.

Jason

Display the Desktop version

It would be very useful to see what version of the Desktop is being run shown on the splash screen and somewhere in the client, not just under the About tab. With the ability to run side-by-side versions of Power BI Desktop to support work with the Service & PBIRS it is important to know which version of Power BI Desktop you are working in.

Episode 95 – Holy Power BI News Batman!

This is episode 95 recorded on April 8th, 2019 where John & Jason talk about all of the news just from last week that the Power BI team announced.


Show Notes

  1. Power BI open-platform connectivity with XMLA endpoints public preview
  2. Enhancing presentation mode with slideshow in Windows Power BI app – minor
  3. Announcing Power BI dataflows general availability
  4. Azure Analysis Services now supported and what’s coming next with Paginated Reports in Power BI
    1. AAS now supported
    2. Paginated Reports using Power BI data sets
    3. New Feature Friday
  5. Power BI Paginated Report Builder Now Available
  6. Workspace V2 is GA
  7. Creating Machine Learning models in Power BI

User Voice Picks of the Week

Jason – Power BI Desktop version release notification

As Power BI Desktop version is getting released every month from Microsoft Power BI, our customer would like to give the latest version of Power BI desktop to users as quick as the version get released. So it would more helpful l if we get email alert notification when the new Power BI Desktop version get released.

Vote!

Episode 94 – Interview with Aviv Ezrachi

This is episode 94 recorded on March 19th, 2019 where John & Jason talk to Aviv Ezrachi, Principle Program Manager for Power BI, about his role with the Power BI Service and his vision for Power BI Development.

User Voice Picks of the week

Jason: Published date

Every report and dashboard pages should have a column for Date Published, modified and by who just like in Windows

Vote!

John: Move Measures Between Tables in New Modelling View

The new Modelling View was delivered in Nov 2018 and is fabulous. There is already a button to select all measures in a table – great. I would like to then move all the selected measures to another table, either by drag and drop or by selecting the home table in the properties list (just like you can do for formatting).

Vote!

Episode 89 – February 2019 Power BI Desktop Update

This is episode 89 recorded on February 22nd, 2019 where John & Jason talk about latest update to Power BI Desktop the including features like update default visual interaction to cross-filter, Insights questions in Q&A, and a bunch of new custom visuals.

This is episode 89 recorded on February 22nd, 2019 where John & Jason talk about latest update to Power BI Desktop the including features like update default visual interaction to cross-filter, Insights questions in Q&A, and a bunch of new custom visuals.

Show Notes

Here’s the complete list of February updates:

Reporting

Analytics

Custom visuals

Data connectivity

Other

Episode 83 – The Death of Inappropriate Anonymous Embedding

This is episode 83 recorded on January 11th, 2019 where John & Jason talk Workspace Management in the Admin portal & the death of inappropriate anonymous embedding.

Show Notes

Easily embed secure Power BI reports in your internal portals or websites

https://powerbi.microsoft.com/en-us/blog/easily-embed-secure-power-bi-reports-in-your-internal-portals-or-websites/

Workspace Management in the Admin portal

https://powerbi.microsoft.com/en-us/blog/workspace-management-in-the-admin-portal/

Episode 82 – 2018 Power BI Wrap Up

This is episode 82 recorded on December 18th, 2018 where John & Jason talk about the highlights of 2018 in the Power BI space & make some predictions for 2019.

Show Notes

Favorite features list:

Show/Hide pages (Jan)
Desktop in the Windows store (Feb)
Slicer sync (Feb)
Persistent filters (March)
Report page tooltips (March)
Bookmarking (March)
Action/Bookmark buttons (April)
Q&A Explorer (April)
Incremental Refresh (May)
New “From Web” Connector (May)
Composite models (July)
SharePoint Roadmap – July
New workspace experience (August)
Monitoring app for Premium (August)
Printing (August)
Aggregations (September)
New Power BI Home (September)
M Intellisense (September)
DAX Editor (October)
Dataflows (November)
New modelling view (November)
Paginated reports (November)
Copy/Paste between Desktop Files (Nov)
Smart guides (Dec)
External Dataflows (December)

Episode 81 – Interview with Andrew Connell

This is episode 81 recorded live at SharePointFest Chicago on December 6th, 2018 where Jason talks Andrew Connell, co-host of the Microsoft Cloud Show and Instructor & Entrepreneur at Voitanos.io, about Azure AppInsights & developing for proper analytics.

Show Notes

Andrew Connell is a full-stack web developer and 12-time annual recipient of the Microsoft MVP Award for Office Development, Office Servers and Services with a deep developer background in SharePoint, Office 365, and Microsoft Azure. He has spoken at various conferences around the world including Microsoft’s TechEd, BuildIgnite & SharePoint conferences, Angular’s ngConfAngularUSPTechConSP Live360 among many others. He’s taught hundreds of people via in-person & online classroom based training for over 10 years including through the training company Critical Path Training he co-founded & co-operated for four years (2009-2013). Additionally, he has a catalog of on-demand video-based training available through Pluralsight. Microsoft has hired Andrew multiple times to present at internal conferences such as TechReady, develop, deliver and publish training courses and to serve as a key strategic and technical advisor to multiple internal product teams.

Over the years Andrew has proven himself time & time again as an experienced technical trainer and course author. Building on this vast experience, he is excited to bring it direct to you to provide the ideal learning experience.

Voitanos is where you’ll find Andrew’s self-hosted video-based on-demand technical training courses and educational resources.

The Microsoft Cloud Show

The only place to stay up to date on everything going on in the Microsoft Intelligent Cloud world including Azure and Office 365. 

Whether you are new to the cloud, old hat or just starting to consider what the cloud can do for you this podcast is the place to find all the latest and greatest news and information on what’s going on in the cloud universe.  Join long-time Microsoft aficionados and SharePoint experts Andrew Connell and Chris Johnson as they dissect the noise and distill it down, read between the lines and offer expert opinion on what is really going on.  Just the information … no marketing … no BS, just two dudes telling you how they see it.

Ep 80 – December 2018 Power BI Desktop Update

This is episode 80 recorded on December 17th, 2018 where John & Jason talk about last update to Power BI Desktop in 2018 including features like Smart guides for aligning objects on a page & the preview of Live connect support for Q&A.

Show Notes

Reporting

Analytics

Modeling

Custom visuals

Data connectivity

Data preparation

Other

Useful links

November 2018 Power BI Desktop Update