BIFocal Podcast

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

• Filter pane improvements
  • Support for full filter pane editing
  • Ability to rename filters
  • Filter pane scales with the report page
  • Restrict ability to change filter type
  • Improved filter pane accessibility
• Conditional formatting for visual titles
• Conditional formatting for web URL actions for buttons, shapes, and images

Analytics

• Drillthrough across reports
• Key Influencers visual now supports continuous analysis for numeric targets
• Python support is now generally available
• Partial synonym matching for terms in Q&A

Modeling

• New DAX function – ALLCROSSFILTERED

Visualizations

• rainbowGauge

Data connectivity

• Power BI dataflows connector now generally available
• Oracle Essbase connector now supports DirectQuery and is generally available
• PDF connector now generally available
• Web By Example connector – automatic table inference
• Intersystems IRIS connector
• Indexima connector
• Luminis InformationGrid
• Solver BI360
• Paxata

Data preparation

• Data Profiling enhancements and general availability
• Fuzzy merge performance enhancements & general availability
• M Intellisense supported in formula bar and custom column dialog & is generally available

Other

• Power BI Paginated Report Builder

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.

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!