This is episode 117 recorded on September 5th, 2019 where John & Jason talk to Chris Webb, Principal Program Manager at Microsoft on the Power BI CAT Team, about Power Query, data consulting, community efforts, and his new shiny new job at Microsoft.
In the current relationship view window we can delete a data table
from the model.
It would be nice to right click on the data table and click edit
query for the underlying table. This would immediately open up the query editor
for data table changes.
Today you have to switch views to the table view, and click edit table. or navigate to the edit queries button and click edit queries. Doing this opens the queries, but you still have to navigate to the table you want to change.
should be a way embedded into the Power BI Desktop or to the Power BI Service
to figure out the actual uncompressed memory footprint.
doesn’t seem to be rocket science, and would save a lot of headache. It would
allow analysts to discover how inefficient their data models are. It would
ultimately help the Power BI infrastructure as well by helping people to avoid
loading the Power BI servers with unnecessary workload.
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.
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.
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.
This is episode 113 recorded on August 14st, 2019 where John & Jason recap all the news that fit to hear from Summer 2019 like Sending refresh notifications to others, Paginated Reports August 2019 Feature Update, Power BI Premium new capacity settings allow for more control over datasets, and more.
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.
This is episode 111 recorded on August 1st, 2019 where John & Jason talk about the latest update to Power BI Desktop including Icon sets for table and matrix, Aggregations now being generally available with RLS support, and the Azure Data Lake Storage Gen2 connector.
This is episode 109 recorded on July 18th, 2019 where John & Jason review some community news, and John interviews Reid Havens of Havens consulting about the Power BI community, consulting in the Power BI world, and template apps.
attributes can be ‘searched’ within report slicers. However, integers cannot.
For example, if someone wants to quickly find and slice by a Customer Id, it is
very cumbersome right now – lots of scrolling. A simple search by Customer Id
(as an integer) within the slicer would make it much faster and a better user
This is episode 106 recorded on June 11th, 2019 at the Microsoft Business Applications Summit where John & Jason talk to Chris Finlan, Senior Program Manager for Power BI at Microsoft, about the recently release features around Paginated Reports in the Power BI Service, Power BI Report Server, and more.
next to impossible to switch between accounts/tenants in the Power BI mobile
client. The user must first log out of the existing account/tenant, and then
establish a connection with the different tenant. This is a multi-multi step
Contrast this with the multi tenant capabilities of the Teams mobile app, or of Outlook, SharePoint etc. We need better account switching in the Power BI mobile app.
current capability we use in Power BI Reports on our Power BI Report Server is
consuming Shared Datasets that are already on the server. We should have a
“Shared Dataset” connector option in Power BI Optimized for Report
Server that helps users identify which Shared Dataset are available on the
server and the parameters(if any) are required to use the shared dataset. This
would be a similar capability that exists in Report Builder when adding shared
This could be a simple UI that ultimately results in an OData source using the PBI REST API. This would simplify adding shared datasets rather than forcing users to under the REST API. Seems like a low overhead improvement that has high potential
This is episode 105 recorded on June 13th, 2019 where John & Jason talk about the latest update to Power BI Desktop including the new look for Power BI Desktop, Certified and shared datasets, and Visual level filters for slicers.
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