Episode 122 – October 2019 news roundup

This is episode 122 recorded on October 29th, 2019 where John & Jason talk about the October Power BI news including refreshing your Power BI dataset using Microsoft Flow, general availability of  Automated Machine learning in Power BI, and the Power BI lineage view.

Show Notes

Introducing Power BI lineage view

Announcing Automated Machine learning in Power BI general availability

Announcing new contact lists for reports and dashboards in the Power BI service

Refresh your Power BI dataset using Microsoft Flow

Keep your Power BI SharePoint reports current with Microsoft Flow

User Voice Picks

John

Allow Pro Users to Publish RDL files from Report Builder

The current version of the report builder can only be published by premium capacity accounts. It would be awesome to include this feature for pro users as well and allow us to add paginated reports to our apps we develop. We have a flat organizational structure and tend to use power BI for clients. We all have pro licenses but there is not much sense to buy premium capacity at this time. However, having this feature would be a huge benefit to everyone using power bi under pro accounts.

Jason

Ability to BLOCK self-service purchase capabilities for Power Platform products

Message centre update refers : MC193609 Self-service purchase capabilities for Power Platform products (Power BI, PowerApps, and Flow) will be available for commercial cloud customers starting 11/19.

We need the ability to block this on tenant level with immediate effect. The platform will become ungovernable in a very short period and cause massive governance issues.

Episode 121 – October 2019 Power BI Desktop Update & News

This is episode 121 recorded on October 15th, 2019 where John & Jason talk about the October Power BI Desktop features including Automatic page refresh for Direct Query, the new Q&A visual and associated updates, and Query diagnostics.

Show Notes

Reporting

Analytics

Visualizations

Data connectivity

Data Preparation

Template Apps

Other

User Voice Picks

Jason

Auto refresh the report

A PBI report is showing 7*24 hours (Full Screen). Now the data gateway has been finished the refreshing. But the data on the report is not be changed. Looks like it is a static page. I must manual refresh. So it is not automatic. Hope enable the report to auto refresh.

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)”.

https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/hide-an-item-report-builder-and-ssrs?view=sql-server-2017

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 this item.

Episode 119 – Power Platform 2019 Roadmap Wave 2 Plan

This is episode 119 recorded on September 27th, 2019 where John & Jason talk through the Microsoft Power Platform 2019 Release Wave 2 Plan and highlight the important Power BI dates over the next few months.

Show Notes

Power Platform Wave 2 Release Plan Document

Power Platform Admin Center

Power BI Features Release Dates

User Voice Picks

John

Connect PBI Desktop to multiple PBI Online Datasets

Currently, once you connect to a Power BI Service/Online Dataset you cannot add additional data sources. We have several datasets we’d like to put in the same report, but can’t because they are over the 1GB limit on size. If we could live-connect to them all in Power BI Desktop this would help.

Jason

Images should have Locked Aspect Ratio

When I add an image to Power BI Desktop, the default setting is that the Aspect Ratio is not locked. This makes the process of scaling the image to a suitable size behave in an inconsistent way compared to (say) PowerPoint. If you turn on “lock aspect ratio”, then the image scales correctly and consistently with other office applications.

Most images should be scaled with a locked aspect ratio.

Episode 108 – Interview with Justyna Lucznik

This is episode 108 recorded on July 12th, 2019 where John & Jason interview Justyna Lucznik, Program Manager on the Microsoft Power BI team, about the Machine Learning abilities in Power BI, the announcements around AI & ML at MBAS and what is still to come.

User Voice Picks

Justyna

Ability to execute R and/or Python scripts on data model data in DAX expressions

Expose a generic function in DAX that takes R/Python script as a parameter to run on data model data. This enables real advanced analytics in Power BI.

Jason

Add labels to Key Influencers

1. Add data labels to Key Influencers so we can see which data points are the outliers.

Currently, the only way to know is to filter categories out, or to do a scatter plot of the 2 variables under consideration. Not practical when having many key influencers.

2. Add color and size options for the graphical view of the influencers, similar to the Scatter Plot visual

-OR-

3. Add the ML capability to show clusters in the data, in addition with the awesome decision tree for the top segments.

John

Machine Learning Models for Pro Users

Please extend Machine Learning capabilities to pro users. Small to Medium sized business may not have the employee count to justify enterprise licenses, but we can still benefit from general capability advancements in the Power BI service/product offering.

Ep 79 – Interview with Jen Stirrup

This is episode 79 recorded on November 28th, 2018 where John interviews Jen Stirrup, Microsoft Data Platform MVP and Regional Director about the state of Business Intelligence and its relationship to Machine Learning and Artificial Intelligence. They spends a little time talking about the competitive landscape.

Show Notes


Jen Stirrup is an industry analyst and speaker, an author, Microsoft Data Platform MVP, a data strategist and practitioner in Business Intelligence, Big Data and Data Visualisation. With nearly 20 years’ experience, Jen works for global clients to deliver strategic advice and implementation in data technologies.

She focuses on R, Machine Learning, database technologies, and Big Data solutions. Jen speaks at conferences such as Hadoop Summit, Microsoft Ignite, SQLPass Summit and SQLBits. She also runs an annual Business Analytics conference in London. Jen blogs at jenstirrup.com and her R, ML and Business Intelligence webinars can be found at datascience.sqlpass.org and bi.sqlpass.org

Useful links

Decency Charter for Technical Communities

Mental Health in Consultancy: You do You

Episode 29 – 2018 Predictions from the Community

This is episode 29 recorded in December 2017… where John & Jason talk to community members about their 2018 predictions & make a few themselves.

A special thank you to Dan Holme for supporting us in this reimaging of his Penton series of Predictions. This was always a fun series of predictions to read, and we hope that you find this episode entertaining to listen to.

Thanks to everyone who contributed a prediction for 2018. Follow them on Twitter and check out their blogs below:

Andy Huneycutt – 5:15

https://twitter.com/AndyHuneycutt

Brian Alderman – 7:16

https://twitter.com/brianalderman
http://www.microtechpoint.com/

Christina Wheeler – 7:38

https://twitter.com/cwheeler76
https://www.sharepointwheeler.com/

Marc D Anderson – 8:20

https://twitter.com/sympmarc
http://sympmarc.com/

Chris McNulty – 9:45

https://twitter.com/cmcnulty2000

Dean Swann –  10:46

https://twitter.com/sdeanswann
https://www.tygraph.com/

Joanne Klein – 11:40

https://twitter.com/JoanneCKlein
https://joannecklein.com/

Jeremy Thake – 12:28

https://twitter.com/jthake
https://jeremythake.com

Susan Hanley –  12:57

https://twitter.com/susanhanley
http://www.susanhanley.com/

Mark Rackley – 13:10

https://twitter.com/mrackley
http://www.paitgroup.com/

Mike Fitzmaurice – 13:48

https://twitter.com/mikefitz
https://www.nintex.com/

Andrew Connell – 14:48

https://twitter.com/andrewconnell
http://www.andrewconnell.com/

Vlad Catrinescu – 15:48

https://twitter.com/vladcatrinescu
https://absolute-sharepoint.com/

David Broussard –  16:02

https://twitter.com/dbroussa
http://blogs.catapultsystems.com/author/dbroussard/

Richard Campbell – 17:10

https://twitter.com/richcampbell
http://runasradio.com/

 

We wish everyone a happy holiday season and a Happy 2018!