Continuing the series on how to connect Dynamics 365 Finance & Operations to Power BI using the Common Data Service (CDS), this is a collaborative post between Robert Watkins (@bortos) and Greg Deckler covering the following:

• Pre-requisites
• Creating the CDS Environment
• Creating the Connection
• Customizing the Entity

Robert Watkins (@Anonymous) and I recently presented at the Dynamics Summit conference on how to create Power BI Dashboards for Dynamics 365 Finance & Operations using the Common Data Service (CDS). Rob handled the Dynamics stuff and I handled the Power BI stuff. So, we figured it would be interesting for the Power Platform community to create a collaborative series of posts on how to use the CDS to connect Dynamics 365 Finance and Operations with Power BI. This is Part 1 of 4.

At the Microsoft Business Applications Summit, our popular Power Hour session features all the wacky, frequently unseemly, and generally funny things members of our product team have created with Power BI. We’re opening a contest and it’s your turn to show us the crazy things you can build with the flexibility of Power BI.

This post will help with streaming data set creation and the execution of a script to a push to Power BI from a complete pandas DataFrame in one request.

Continuing the analsyis of performance tuning a DAX calculation from 10 minutes to 20 seconds.

Is there a simple way to convert a timestamp in UTC to your local time zone in Power Query? Yes and no. Let’s find out what the options are.

Take a DAX calculation from 10 minutes to 20 seconds.