Episode 103 – The Road to MBAS
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.
Microsoft Business Applications Summit
Connect to Power BI dataflows and datasets using Power BI Desktop with multiple accounts
Connecting Power BI workspaces and SharePoint sites
User Voice Picks
Make OneDrive a default Get Data connector
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.
Prompt the User Before Creating a Hierarchy When Fields are Dragged Onto Each Other
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 Hierarchy