Connecting Power BI to Microsoft Dataverse for Teams
It’s quite straightforward to connect Power BI to Microsoft Dataverse for Teams, and here’s how.
By way of a reminder Microsoft Dataverse for Teams is a platform for building Apps, Chatbots and Automation Flows.
You can find out more in this video
An you can sign up for the free Dataverse for Teams course here
Onto the main event – so you’ve built a table, you’ve created an app, but you’d like to create some insight using Power BI. There are 2 ways of doing this, the suggested method, which doesn’t work for me. And the way that did work for me.
Tried and Tested Method
The following video walks you through the process
Get the URL
- Go to Teams
- Select the Team you are interested in
- Go to the about menu
- Open the session details
- Grab the Instance URL – it will look like https://orgxxxxxx.crm4.dynamics.com/
- Add the following to the url
api/data/v9.1Your URL should look like this now
https://orgxxxxxx.crm4.dynamics.com/api/data/v9.1Start working in Power BI Desktop
7. Open Power BI
8. Get Data
9. Choose Dynamcis 365 Online
10. Use the url from above. Make sure that you are correctly authenticated 🙂
11. Identify the tables you require
12. Close and Load
13. Establish the relationships between tables
14. Start building visuals
Microsoft Approved Method
I couldn’t actually get this one workinig, and as it’s very new that may be the reason. Thiis is very similar to the above, but you don’t add api/data/v9.1 to the URL and you use the “Common Data Service” beta connector.
The details are shown here
I trust that this helps you to be more successful with Microsoft Dataverse for Teams