This is episode 103 recorded on June 7th, 2019 where John & Jason talk about the Microsoft Community, plans for the Microsoft Business Applications Summit, a few bits of news, and some recent helpful blog posts from John.
Please add a OneDrive data source option in Power BI.
It is incredibly frustrating that Power BI does not come with a
OneDrive for Business option baked in and is especially strange since OneDrive
belongs to Microsoft. It seems like this would have been present in the
application from Day 1.
Having to manually locate a file outside of Power BI, identify the
correct URL for the file in a OneDrive account, and then having to plug that in
to Power BI is unnecessarily convoluted and is particularly difficult for new
Power BI users to manage.
How many times have you dragged a field onto another field by
mistake and have it create a hierarchy?
It happens quite often. Usually I am trying to drag the field to the
Visualization pane but fail to hold the mouse button. And lo and behold it
creates a hierarchy. (Which I then have to delete. But sometimes I do not even
notice that I accidentally created a hierarchy).
It would be nice if a prompt came up, asking if we want to create a
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.
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!
This is episode 97 recorded on March 21st, 2019 where John & Jason talk to the SQL All Father himself, Matthew Roche, Senior Program Manager on the Power BI CAT team, about Dataflows, sword play, and much more.
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!
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
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.
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.
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.
This is episode 94 recorded on March 19th, 2019 where John & Jason talk to Aviv Ezrachi, Principle Program Manager for Power BI, about his role with the Power BI Service and his vision for Power BI Development.
User Voice Picks of the week
Jason: Published date
Every report and dashboard pages should have a column for Date Published, modified and by who just like in Windows
John: Move Measures Between Tables in New Modelling View
The 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 formatting).
This is episode 93 recorded on March 18th, 2019 where John & Jason talk to Kim Manis, Principal Group Product Manager for Power BI, about her role on the Power BI Team and her vision for Power BI Desktop.
User Voice Picks of the Week
You should be able to insert a hyperlink field into a visual so when a user selects on the visual, it can take them to the desired page.
is episode 92 recorded on March 15th, 2019 where John & Jason talk about
latest update to Power BI Desktop the including features like Single select
slicer, filter pane improvements, and some accessibility improvements.