How Do I Create Power BI Report with Direct Query in Dynamics 365?


Last year December, Microsoft announced the general availability of Power BI Direct Query for Microsoft Dataverse or Dynamics 365 Customer Engagement apps. Now with TDS – tabular data stream and Power BI Direct Query, Power BI users have more options to connect to Dynamics 365 environments.

The benefits include the better discovery of the Power BI Dataset model, support for real-time information, support for the security model of Dynamics 365 apps, and the flattened structure of complex data types like lookups and option sets.

To get started with TDS for Dynamics 365

Login to Power Platform Admin Center, select the Environment and navigate to Settings > Features, and enable Power BI Embedded content and TDS endpoint as shown below.


Open the Power BI Desktop and login with the user whom you would like to access the data.

Download it from the following location


For the Get Data option select SQL Server database

Provide CRM development company and CRM URL in the server and DirectQuery as the connectivity mode.


Select Opportunity as the table for the report and click on Load.


This loads the Opportunity fields for us to use in the Power BI report.

Your BI report makes all the difference

When it is prepared with direct query on Dynamics 365. Are you ready to empower your organization with this power with our guidance?

Drag the stacked column chart.


Specify Axis and Values fields.


This is how the report will look like


Save and Post the description to Power BI Service


Within Power BI Services, update the credentials details of the Dataset.

Specify the Authentication method as OAuth2 and Privacy level settings as Organizational.


Now you can easily embed the Power BI Report within Dynamics 365 Dashboard as shown below.

Related article

Power BI is a suite of Smartphone platforms developed by Microsoft for use on several mobile devices. The Power BI Report Server, for example, is a web interface that is physically located on the premise and that you can use to handle reports and key performance indicators (KPIs).

Microsoft has launched 2020 release wave 1 on 1st of April which includes new applications and as well as around 400 new features across both Dynamics 365 and Power Platform.

Today, the healthcare business is putting out significant effort to address concerns such as technological implications and improved consumer satisfaction. It had already begun for the healthcare provider to deploy the numerous technology applications in their field of expertise. In addition, they are focused on improving the customer interaction among the provider and its (patients), which will eventually result in increased customer satisfaction and loyalty. People like to believe that they are receiving customized attention. They don’t need to be served as a number.

DMCA Logo do not copy