how to put some values from azure SQL database to dynamics 365 dashboard or portal?

(0) Share

Report

Posted on by Ashish Moradiya

515

Hello,

I have some data in Azure SQL database I want to show this data to Dynamics 365 screen or Dynamics 365 portal. Is there any way of such integration? Power BI is also acceptable In between Azure SQL database and Dynamics 365. if it is possible do through Power BI.

Please provide suggestion if anybody knows about it?

Regards,

Ashish

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

Friyank 944 on at

Like (0)

Report

RE: how to put some values from azure SQL database to dynamics 365 dashboard or portal?

Check below link

https://community.dynamics.com/crm/b/exploringdynamics365/archive/2017/09/11/virtual-entities-in-dynamics-365

Alternate entity is best and correct option.

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

RE: how to put some values from azure SQL database to dynamics 365 dashboard or portal?

Once the connection is established between Power BI and Azure SQL database, you could create the required representation of the data in the reports and pin them to a Power BI dashboard. This power BI dashboard can be shown in the Dynamics CRM or a tile can be shown in Dynamics CRM dashboard.

www.microsoft.com/.../add-or-edit-power-bi-visualizations-on-your-dashboard.aspx

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

RE: how to put some values from azure SQL database to dynamics 365 dashboard or portal?

Hi Ashish,

You could download Power BI for desktop from the link below and connect it to Azure SQL database.

powerbi.microsoft.com/.../desktop

For more information on how to connect Power BI with Azure SQL database, follow the steps in the link below.

radacad.com/power-bi-get-data-from-azure-sql-database

Hope this helps.

Was this reply helpful? Yes No
Verified answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

RE: how to put some values from azure SQL database to dynamics 365 dashboard or portal?

You should be able to query your Azure SQL database using Power BI and display that in a Power BI tile on the CRM dashboard. Dynamics 365 (v8.2.1) allows you to display tiles from a Power BI personal or organization report/dashboard.

You should verify that you have the proper Power BI licenses for this purpose.

Was this reply helpful? Yes No
Verified answer

MihirShah 4,036 on at

Like (0)

Report

RE: how to put some values from azure SQL database to dynamics 365 dashboard or portal?

The latest iteration of Dynamics 365 has a new feature called "Virtual entities". You may want to try that option.

blogs.technet.microsoft.com/.../virtual-entities

Was this reply helpful? Yes No