Episode 127 – November 2019 Power BI Desktop

This is episode 127 recorded on November 14th, 2019 where John & Jason talk about the November Power BI Desktop features including the new Power BI Desktop Ribbon, Decomposition Tree, and AI Functions in Power Query.

Show Notes

Other News

Office 365 Service Description Power BI Report

A low cost approach for paginated report subscriptions in Power BI

Desktop November 2019

Other

Reporting

Analytics

Visualizations

Data connectivity

Data Preparation

Template apps

Ideas

Option to use either light or dark interface

Dark Mode for Power BI

Jason’s pick

No Ctrl-Click on Buttons Needed for Bookmarks View Mode

When editing in Desktop, you have to Ctrl-Click a button to trigger the assigned action – very good. But when you have multiple bookmarks and you go into “View” mode, you are effectively in “PowerPoint Mode”. When in this mode, there should be just a single click for a button (no ctrl needed).

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38773519-no-ctrl-click-on-buttons-needed-for-bookmarks-view

Episode 126 – Ignite Wrap Up and Unconference Outcomes

This is episode 126 recorded on November 8th, 2019 where John & Jason talk about Microsoft Ignite, the announcements, the demos, and what recommendations came out of the working groups at the Power BI unconference.

Unconference recommendations in User Voice at https://ideas.powerbi.com

We need real time monitoring of Power BI dedicated capacities

Allow us to set the default time zone for our Power BI tenant, and have a report level override

Display tabular data as is without aggregation

Report First Data Model Design

Power BI premium capacity metrics – extend it to beyond 7 days.

Premium metrics – Aggregate data across capacities

Episode 125 – Microsoft Ignite Round up with Adam Saxton

This is episode 125 recorded live at Microsoft Ignite on November 8th, 2019 where John & Jason interview Adam Saxton, Microsoft’s “Guy in a Cube”, about the Power BI community, what announcements Microsoft made this at Microsoft Ignite, and expand upon Adam’s Guy in a Cube Round Up for November 11th.

Show Notes

Killer Power BI updates at MS Ignite (Guy in a Cube Roundup | November 11, 2019)

Weaving Business Intelligence into the fabric of the organization with Microsoft Power BI

Large models in Power BI Premium public preview

Microsoft Power BI: Distributing insights and governing self-service analytics with the Power BI service

Episode 124 – At Microsoft Ignite with Arun Ulag

This is episode 124 recorded live at Microsoft Ignite on November 4th, 2019 where John & Jason talk about some new blogs posts from John and interview Arun Ulag, General Manager of Power BI Engineering at Microsoft, about all things Power BI, what announcements they’ve made at Microsoft Ignite, and some glimpses into the future.

Show Notes

Embed paginated reports in your own application for your customers (Preview)

Announcing Enterprise Information Management Capabilities in Power BI

Large models in Power BI Premium public preview

Episode 120 – October 2019 News Roundup

This is episode 120 recorded on October 2nd, 2019 where John & Jason talk about the Microsoft Ignite schedule builder and a whole bunch of news items from the last month.

Show Notes

Power BI Report Server September 2019 Feature Summary

Template apps update (preview) is now available

Paginated Reports in Power BI September 2019 Feature Summary

Power BI Dataflows September 2019 Feature Summary

Announcing the Microsoft Business Applications October Virtual Launch Event

URL parameters for Paginated Reports are now available

What’s new for SQL Server 2019 Reporting Services RC1

What’s new for SQL Server 2019 Analysis Services RC1

User Voice Picks

Jason

The ability to message all Power BI users from the Power BI service

If you run a Power BI platform for a lot of users you should be able to send /push notifications to them. We are currently experiencing high fail rates and it would be great to alert all users that we’re busy looking into it.

John

Support creating calculation groups in Power BI Desktop

Support the creation of DAX calculation groups in Power BI Desktop – otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model.

Even just a simple text window with a script would be fine. You can clean up the UI later.

Thanks.

Episode 107 – Power BI News and MVP Renewals

This is episode 107 recorded on July 2nd, 2019 where John & Jason talk about MVP Renewals, the World Cup, and a whole bunch of Power BI News including the New Viewer Role for Power BI workspaces, the June dataflows updates, and a new version of Power BI Report Builder.

Show Notes

Power BI Dataflows June 2019 Feature Summary

Announcing the New Viewer Role for Power BI Workspaces

Introducing dataflow templates; A quick and efficient way to build your sales leaderboard and get visibility over your sales pipeline

Avoiding workspace loops by expanding navigation properties in the GetGroupsAsAdmin API

Power BI Paginated Reports June 2019 Feature Update Summary

Announcing support for non-Premium Power BI datasets in Power BI Paginated Report Builder

User Voice Picks

Jason

Power BI Desktop: Option to use either light or dark interface

New Desktop app update installed an almost white user interface. There is zero contrast which is not good for the eyes. I see where some people have requested a light interface so incorporate an option to select either light or dark theme like in the Office apps.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37882726-option-to-use-either-light-or-dark-interface

John:

Visibilty (Hide an Item)

Develop an item formatting property which allows to set the visibility of a report item when you want to conditionally hide the item based on a report parameter or some other expression that you specify (also DAX expressions).

You can develop this incrementally starting from visuals, then text boxes, then shapes and buttons….

If you want to go the extra mile, you can also develop a functionality that allows the final user to toggle the visibility of report items.

For more information and since it was an available and really useful capability see “Add an Expand or Collapse Action to an Item (Report Builder and SSRS)”.

I double checked in the ideas database and there are many ideas describing the same functionality; this is the reason why I do believe this is really required and will try to collect all the previous votes under

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item

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 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 77 – Interview with Arun Ulag

Thisis episode 77 recorded on November 21st, 2018 where John & Jason talk aboutsome new blogs posts from John and interview Arun Ulag, General Manager ofPower BI Engineering at Microsoft, about all things Power BI at MicrosoftIgnite on September 25th, 2018.

Show Notes

About Arun
https://www.linkedin.com/in/arun-ulag-086b576/

John’s blog posts

USE POWER BI DATAFLOWS TO WAREHOUSE SHAREPOINT LIST DATA

GET THE MOST OUT OF POWER QUERY IN POWER BI DATAFLOWS

Have a question you want answered? Drop us a note or send us a .WAV file of your question at info@bifocal.show and we will answer your question on the show in our end of year wrap up show.