Power BI and the Dataverse
Links:
Sign up to our Meetup group https://www.meetup.com/hybrid-virtual...
Join our LinkedIn group / 12487. .
Follow us on Twitter / hybridvug
...and of course don't forget to subscribe to our channel, like the video, and hit the bell! It really helps us in our mission to produce free content for the masses.
Session Details:
The Dataverse is the preferred data source to all of the app-building currently happening in the Power Platform sphere, and now that Dataverse for Teams is an option (given that doesn’t require an extra license), expect it to be appearing even more in your data ecosystem!
So all this means that people will be requiring Power BI reporting from the Dataverse and the problem is that this data model is not carefully crafted by data engineers -it is being built by citizen developers!
This session will look at some of the interesting challenges that Dataverse introduces to Power Query and Power BI, including many more relationships than anyone could possibly want, plus internal and display names for tables and columns.
Speaker:
Laura Graham Brown is a Microsoft Business Applications MVP and has over 20 years of experience at being passionate about training, solving problems, and loving a new challenge. I have worked with household names and clients very few will know, from the huge corporations to the small businesses, helping them make SharePoint, Flow, PowerApps, Power BI and Office solve their business needs.
Host/s:
Mark Broadbent.
Mikael Wedham.
Originally recorded on 8th September 2021.
Video Production: Mark Broadbent 5th December 2021.
00:00 Introduction
03:11 Adding, editing, and navigating Dataverse records (demo)
11:29 Connecting to Dataverse in Power BI (demo)
15:37 Browsing the Dataverse model in Power BI (demo)
18:55 A better way to load your Dataverse tables and relationships (demo)
21:51 Using the Power Query helper tool (demo)
34:14 Defining relationships for the Dataverse model (demo)
36:10 Create simple Power BI report from the model (demo)
42:00 Summary
42:26 Questions