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.
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.
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.
User Voice Picks
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.
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.
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.
- Automatic page refresh for DirectQuery (preview)
- The new Q&A visual
- Improved user experience for Q&A
- Improved drop-down control
- Red/Blue underlines
- Improved visual results
- Natural Language improvements for Q&A
- Integration with office/Bing thesaurus
- Support for measure tables & better handling of table names and ambiguity
- Row label and synonyms support inside Modelling pane
- Q&A tooling
- Review questions
- Teach Q&A
- Review all changes made
- Support for SSAS and Azure AS including RLS (Preview)
- PowerApps visual is now included by default
- New xViz visuals
- Sagra Emigo connector generally available
- Azure Cost Management connector updated
- New Workplace Analytics connector
User Voice Picks
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.
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 this item.
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.
User Voice Picks
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.
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.
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.
Power BI Features Release Dates
User Voice Picks
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.
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.
This is episode 118 recorded on September 19th, 2019 where John & Jason walk through the September 2019 Power BI Desktop update, and highlight some important user voice picks.
- Color and text classes in themes
- New default themes
- Personalized visualization pane improvements (preview)
- Custom format strings
- Conditional formatting for more visual formatting options
- Drill through discoverability improvement
- New DAX expressions: REMOVEFILTERS and CONVERT
- PostgreSQL connector enhancements:
- Performance improvements for multi-dimensional models
- Query performance improvements for DirectQuery models
User Voice Picks
Please introduce a global setting to Prevent Teams from creating Power BI App Workspace automatically when creating a new Team. As the new Workspaces are detached from Teams/Groups this should be a setting to prevent the App Workspaces being clotted with empty Workspaces from all our Teams.
Report themes are great. For quite some time we have been able to build JSON file that describe themes. At first they were relatively simple, but have evolved to include theming options for virtually every aspect of a report.
The September 2019 edition of Power BI Desktop introduces a massive number of additions to theming. There are now so many that simple, textual JSON file editing is now impractical. We NEED a graphical theme editor.
Power BI Desktop itself could act as the editor with one simple feature addition. Export current visual settings to a theme file (JSON). With that, Desktop could be used to get things “just so” and then save out the JSON for re-use.
This is episode 116 recorded on September 5th, 2019 where John & Jason talk to Marco Russo about Analysis in general, community efforts, and his new book, The Definitive Guide to DAX, 2nd edition.
Marco’s latest book on Amazon – The Definitive Guide to DAX (2nd Edition)
Guy in a Cube Power BI courses – Use the code “bifocal10” for a 10% discount
User Voice picks
As of now, the reports that I create on desktop utilize a lot of time intelligence functions and relative date filters. This is completely fine so long as I view the report on the desktop. Once I publish the report up to the service and then utilize those visuals in dashboards I run into this issue. All of my time intelligence functions (TODAY & NOW) and relative date filters convert to UTC.
This issue causes my data to roll over to the next day 5 hours early which affects all of my subscriptions.
It would be absolutely fantastic if Power BI service could recognize local time zone or even if we could manually set our time zone so that these measure work correctly.
I would like to have the ability to do a “compare tables” or “compare queries” option.
I understand that there are visuals/queries I can build to compare the DATA within two separate queries but I want to compare the two queries. I want to know how many columns are in TableA versus how many are in TableB and which column names are different from each other. When I have two tables with 150 columns (give or take) and they are allegedly a copy of each other I want to be able to confirm that all 150 in columns in TableA match all 150 columns in TableB and that I don’t have 10 unique columns in each query that just happen to come up to 150.
It would be nice to get a row count difference at the same time, but I do know that I can do the count rows to get that number of each.
This is episode 115 recorded on August 29th, 2019 where John & Jason talk about the latest News, Ignite update & the August Power BI Desktop news including Grouping visuals, Measure support for the Key Influencers Visual, & some new Data Connectivity.
August 2019 Desktop Update
- Grouping visuals
- Filter pane auto-update
- Icon style picker for Icons conditional formatting
- Conditional formatting warnings
- Support for SAP HANA HDI Containers
- Edit SAP variables in Power BI Service (preview)
- PostgreSQL DirectQuery (beta)
- MarkLogic connector now generally available
- New Power Platform category within Get Data
User Voice Picks
As Microsoft increasingly supports tailored experiences, we need the ability to operate as a user with equivalent or fewer credentials, including just not being the person who added information.
For example, a site owner who made updates to a site is seeing Updated Pages (with explicit pages underneath) in the left navigation, but has no rights to remove the navigation and didn’t realize that other people weren’t seeing those pages.
Another case was where the SCA had no issue opening a document with embedded documents, but it would not open for site owners and contributors.
In our on-prem environment, I was able to use a test account and assign it with certain rights to verify that those users were going to get the experience I intended, and I was able to do that with a test account. In the SharePoint Online world, for an out-of-the-box solution I’d need a second licensed account for testing in production.
Checking permissions to a site, list, library or item helps, but just isn’t enough for testing the experience on a page in or in a solution.
A potential way to implement this would be to allow me to click on the name I’m logged in as, and in addition to About Me, Sign Out and Personalize this Page, have an option to impersonate a specific user (who has fewer or equivalent rights to me) or a certain level of rights (equivalent to or less than the rights I have).
Some developers in teams help test each other’s solutions, changing who has what rights, but for those of us who largely work independently, we don’t have that luxury.
In the query editor, queries can be grouped (and sub grouped). However, back to Power BI desktop, under the Fields pane, the queries are listed without grouping. Need to retain the same grouping.
Also, when publish the dataset, need to be able to hide some query groups from the user.
Similar to “Add Folders to organize fields“
This is episode 114 recorded on August 21st, 2019 where John & Jason talk to Chris Finlan, Principal Program Manager for Power BI, about his experience at SPFest, whats new and exciting in Power BI, and some specifics around Paginated Reports in Power BI.