Quickly get Dynamics 365 data in to Power BI for Q&A

The Q&A feature in Power BI is great as it let’s users ask natural questions about your data and it will generate visuals and lists to answer those questions.

Of course, there’s an assumption that Power BI has a data model that uses the same terminology as the user asking, and that the required data is in the model.

The concept of this video, is to have a look at how fast we can build a data model in Power BI, on Dynamics 365 data and start asking questions to the data to create a report.

The “secret sauce” in this video is the Power Query (M) Builder for the XrmToolBox.

For an in-depth look and the ability to ask questions, attend a live webinar on how to use the Power Query Builder on:
Tuesday, Aug 21, 2018 10:00 AM – 11:00 AM PDT.
The tools used plus the webinar are of course free!

Sign up here. https://register.gotowebinar.com/register/173263633764231171

Here’s the video highlighting how I build a data model in Power BI, on my Dynamics 365 data and create a report in about 10 minutes.

Enjoy. As always, please sign up for my newsletter or follow me on Twitter 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s