Dataverse + Power BI: What you didn't even know you needed!

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
- Yooo! - What's up? I'm Adam. - I'm Scott. - And we are gonna talk about Dataverse. What this Dataverse is and why you need to be using it right now. All right, let's do this. (upbeat music) If you're finding us for the first time, be sure to hit that subscribe button to stay up to date with all the videos from both Patrick and myself. Scott, I am so glad you are here to join me in this video. So for those that don't know, this is Scott Sewell. He is a PM on the Power BI CAT team. You may have heard us talk about Power BI CAT before. There's a bunch of great people there just helping large enterprise customers adopt and grow with Power BI, and Scott, you are part of that magical team. And I know that one of your passion areas is Dataverse. - Yeah, Dataverse is part of the Power platform, which Power BI is part of the overall business application platform, but Dataverse is really a data supplier to a lot of the Power platform. It's not a database per se, but it's really a service that allows you to build as if you're kind of building on databases, where you're building your tables, your charts and things like that. You can put it in there and then it layers a layer of security, integration to Azure, AAD, and- (Adam chuckles) Azure Active Directory. (Adam laughs) - That's the one. - There we go. - Thank you. It's easier for you, so yeah. So it builds it. The security is modeled in there and it really serves as that data layer for Power Apps, Dynamics, and just any kind of app you wanna build. There's portals and things on top of it. But it's really designed as an easy to use or a quick way to develop business applications primarily for inside the business. - So I like data. I love data, actually. I have a shirt. You said a word there that is interesting. You said, Dynamics. - [Scott] Dynamics. Yeah. - [Adam] Do I need Dynamics to use this? - The great thing is this actually evolved out of Dynamics. And because it's so useful, Microsoft has made it available. So even if you're not using Dynamics, you can still use that data platform that Dynamics is built on top of. And in fact, a lot of our users, or a lot of our customers are building applications that have nothing to do with the traditional Dynamics applications, they're building it using Power Apps on top of Dataverse. It's easier to confuse it. It's not a competitor to Azure SQL. In fact, way down underneath the layers, there is Azure SQL that this is running on. - All right, Scott, enough of all this talking. Let's head over to your machine and actually see what this is and play around with it a little bit. - [Scott] Sure. Now I'm gonna open it up inside of Dynamics 365. We're really thinking about what's going on underneath that front end layer. It's an application that hosts records, in this case, I'm looking at account records, but they could easily be an inventory or some other type of record that you keep inside of a business. I see it used for in schools, I see it used inside of factories for maintenance types of work. I've seen lots of different use cases where we're just collecting data, managing it inside of Dataverse and exposing it either through Dynamics or through a Power App. One of those things in place. So here's an example. I've just got a list of records here, and, of course, I can drop into a record and open it up. I've got details about it. Things that you would expect to see. The nice thing is all this can be configured with no code really as a citizen developer. That's where that sweet spot is, no code, low code. And as a result, it's actually become very widely adopted very quickly. So it's been fun to see the growth of that over the years. - [Adam] All right, so we're in Dynamics. What do I need to do? 'Cause I haven't used Dynamics, I'll be honest. Don't judge me. - [Scott] Dynamics is just kind of the face of it, but all its data is sitting inside a Dataverse. In fact, you can go down below there and see the tables, the construction of those and the schema. Power Apps is another face of it, but this is that maker portal that configures Dataverse - [Adam] Awesome. - To support either of those products. So in this case, if you see on the left side, I've got a data menu here. In fact, in a newer version of this, this actually says Dataverse right there, but you can see that I've got tables. In this case I've got accounts and addresses and contacts, et cetera. But I could create new tables as I go and begin tracking that in there. And the team that I work in, we use it to track conversations we're having with some of our enterprise customers, questions they've had or suggestions they've had about the product, enhancements they would like to see, we're tracking that inside of a Power App. And now all that information is being stored through the Power App as the front end, but in the back end, it's being stored inside of Dataverse. - It's just Power Apps on top of Dataverse, not necessarily having to use Dynamics at all. Although, I mean, Dynamics is there if you wanna go that route, it's available. - Dynamics is kind of, we considered it our first party app. It sits on top of it. Maybe think of it as a big pre-configured Power App. (Scott chuckles) - Nice. All right. - With a lot of additional features, you know. - I'm gonna use that. - It's one way of saying it. Yeah. (Adam laughs) Nice. All right. - You know, in this case, I'm looking at the columns and I can see relationships between tables. I've got business rules that are there. I create views, forms, all kinds of things, even down to the data itself. As I'm entering this, as I'm working through this, one of the exciting things has been seeing the data that's being captured and collected and processed in this Dataverse through the Power Apps or Dynamics and bringing it out through Power BI, of course. Power BI is amazing way - Of course, of course. - [Scott] To help business decision makers understand the value of the data that they're sitting on. In this view that I have in the app. By the way, all this is fake data, but I thought it was just created so I could see some examples going on. - [Adam] I see myself there. - [Scott] (indistinct) here. - [Adam] I'm in opportunity. - [Scott] You're an opportunity owner. Yeah. - [Adam] Oh, okay, I'm an owner. - [Scott] And you're doing really well, by the way, I'll show you in your example. - [Adam] I like to hear that. (Adam laughs) - [Scott] You own a good shot. - [Adam] Nice. - [Scott] I'll talk to you about next quarters. - [Adam] All right. - [Scott] So anyway. So but in this case, I can look at the data. I've got some very simple charts that I can do that are part of the Dataverse Power App platform. I can do some simple visuals like that, but going beyond that, we started adding additional integrations with Power BI. You'll notice I've got a new button here, and this one is only in preview. So it's a fairly new button. And I only got it in my environment, I guess, last week, but I can click this and choose, visualize this view. It's taking a look at that view that I have in front of me on the screen and saying, let me create a sort of a temporary Power BI report on top of that view. It just uses AI to say, let me grab some of the columns that are in there. - What I like say here in Guy in a Cube is that in relation to DirectQuery, is that auto-generated T-SQL is the best generated T-SQL. In this case. - Oh, yeah. - The best Power BI report is the auto-generated Power BI. - Power generated. - It's amazing. - That's right. - It's bananas. - Yay, it's exciting. I don't have a catchphrase for us, (Adam laughs) but we'll do it with that. But I can make some changes and visualize the data. You can see the columns coming over. I've got charts, I've got suggested texts. Now, one thing is in the current version, as soon as I close the window it goes away, sort of a femoral at the moment. Possibly future versions will allow me to say export that or save it as the dashboard- [Adam] Maybe to a workspace or something. - My workspace. If you're a Power BI professional, it's important to kind of be aware that this is happening. Maybe you're involved in a Power App or a Dataverse part of the business, or maybe not, and you see some people at the organization using it, be aware that this is an opening for you to be able to step in and provide some leadership and some service. That's where really you can bring a lot of value into these organizations. These applications, they are rich in data. The opportunity to turn it into deeper data or expand it and- Or just exploring that data and finding those insights into what's going on. Like that's where Power BIs really comes in to help with that. - Yeah, and here's an example of how I see it used with Dataverse right now, is being able to bring Power BI reports into a Dataverse record and filter the report according to the context of the record I'm on. What does that mean? As I go to a record and we jump onto A. Datum Corp, I'll open up the record in Dataverse and I'm looking at it, I've got the values from Dataverse, but I've also added this analytics tab. And in the analytics tab, I can bring in a Power BI report and I filtered the report to A. Datum. So imagine if you're looking at records in your system and I can go to multiple systems, pull all those Power BI reports that are scattered across multiple workspaces, multiple models, pull those together inside the record for a single account, makes that account much, much more rich in terms of 360 degree view. It's kind of like a navigation tool to say, we've created all these reports for you, but instead of having to go into each report and refilter it, we should bring them all together in multiple tabs in these entities. - You're bringing that report to the user in the application they're using without them having to switch context and go back over to Power BI. So that's powerful and that helps. The other thing that's interesting there is you could even craft that report to be more like the application. So instead of having like a separate header and all that in the report, just make it look like it's just part of the application and user doesn't even need to know it's Power BI. - The data that's in here can be data from any system that's out there. Anything that you can connect Power BI to. So it's really a powerful way of bringing the data to the user as opposed to making them go find it. - This is nice. I'm getting excited about this. So for someone just watching this, like you've already got data set up, right? You've already got the report, you got everything going. How does someone just get started with this? What's the starting point? - [Scott] The great thing is because it's all part of the Power platform, it's really easy to get started between the two. When I go into Power BI. In fact, if you've opened up Power BI in the last several months, you've noticed up in the ribbon, there is a Dataverse button. It's a link directly to Dataverse just like we can connect to SQL or Power BI data sets or Excel. If I open that, it's gonna establish a connection and point out all the Dataverse tenants that I have permission to see. I can pick one and go ahead and bring that data in. - [Adam] Yeah, and then it's just normal Power BI at that point, right? - [Scott] Yeah. (indistinct) Power BI. - [Adam] 'Cause we've connected to the data. So now we can shape it in Power Query and we can model it if we need to model it, bring it alongside other data if we're importing and then create that report on top of it. Does it allow for DirectQuery as well or? - Great question, Adam. I mentioned before, Dataverse has this really rich and complex security models tied to the AD account. It has raw level security and everything. Well, instead of having to rebuild that, you can just use the Dataverse connection and do a DirectQuery against it. That's only been available in the last year or so. That's really appropriate for those, I'm gonna call them smaller data sets. Once you get up into the millions of records or even hundreds and hundreds of thousands of records scenario. Inside of Dataverse, we've got a new magic button called Azure synapse link. Dataverse now has this link that synchronizes that to a data warehouse so I can consume it through synapse if I wanted to. - [Adam] Nice. Now we're leveraging the power of synapse and Power BI and everything together? - Yeah. The nice thing is it gives you that no cliffs experience, where you can do small data sets or you can do large data sets, or ginormous enterprise data sets (mumbles) - Helps you scale. helps you scale. Scott, any limitations that you wanna call out, just pitfalls that people may run into that you want them to be aware of. - Yeah. Sure. Dataverse has by default, because it has a lot of stuff pre-built for you, there's a lot of fields. Some of the out of the box field entities can have upwards of 1000 fields. - You don't wanna do that. - Now, (both chuckle) you don't wanna do that. So my first step in a report is always, when I go into the transform data, I'm always going up and saying, choose my columns just so that I choose to pull only the columns that I wanna to pull into the report and leave all the rest of them behind. That's an important first step. The second important step, and that's gonna be whether you are doing DirectQuery or import. As a Power BI professional, you don't wanna try to pull in like long text rings, like bodies of emails. Those are just not necessarily appropriate. The other thing to be aware of is Dataverse has the schema that's built as a relational data model. It's got all these interconnections. That's not the model that works best for Power BI. What we wanna do is work with the folks on the Dataverse side and help them translate what they're doing into a star schema. - [Adam] Yes. - It's a bit of a struggle. I mean, I came from the Dataverse side and I kept resisting the star schema. I kept fighting against it. (Adam chuckles) My first reports, I just tried to dump everything plus the kitchen sink into my report. Bad, bad, bad. - [Adam] Bad idea. - Yeah, bad idea. The expertise you have as a Power BI person, you need to be able to use that and think of how you can bring that expertise forward and help somebody from the Dataverse side translate the data and the questions that they have into a model that you can build in Power BI. - Love it. Love it. - I'm really interested in seeing, if you're using Power BI with Dataverse, or you've got people using Power Apps, have you connected the two together? I'd love to know what you're doing and what you've heard so far. If you don't mind, just leave a comment below and let me know what's going on. - If you liked this video, be sure to hit that big thumbs up button. Smash it if you so desire. If it's your first time here, hit that subscribe button. And as always, from both myself, Patrick and Scott, thank you so much for watching. Keeping awesome, and we'll see you in the next video.
Info
Channel: Guy in a Cube
Views: 52,149
Rating: undefined out of 5
Keywords: dataverse, dataverse dynamics 365, dataverse explained, dataverse for beginners, dataverse overview, dataverse power apps, dataverse power bi, dataverse power platform, dataverse powerapps, dataverse tutorial, microsoft dataverse, microsoft dataverse tutorial, power bi dataverse, what is dataverse, what is microsoft dataverse, common data service, dynamics 365, power apps, power automate, power bi, power platform
Id: c1S-8rl7t1Q
Channel Id: undefined
Length: 12min 45sec (765 seconds)
Published: Thu Dec 16 2021
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.