Microsoft Dynamics 365 | Integration, Dataverse...

Unable to connect my PowerBI to Production database to see inbuilt Power BI Dashboards, need urgent help please

(0) Share

Report

Posted on by Venki Guru

Trying to use the PowerBI inbuilt Dashboards for our customer. But no one including MS is not able to guide us correctly to activate the dashboards.

We are seeing dummy data and real data to showcase Sales, Finance and Inventory dashboards,

Please help

Regards

I have the same question (0)

All responses (7)

Answers (0)

Ruth Aisabokhae on at

Like (0)

Report

Hi Venki,

I have moved your question to a more appropriate forum, and hope you get the help needed.

Thanks,

Ruth

Was this reply helpful? Yes No
MSTGuy 310 on at

Like (0)

Report

This guide will help you in building a PowerBI dashboard for Microsoft Dynamics 365:

trellispoint.com/.../

Was this reply helpful? Yes No
Venki Guru 10 on at

Like (0)

Report

Thanks for your help.

We are looking to connect to D365 F&O and not CRM at this point.

Can you help us also how to connect to D365 F&O Power BI embedded dashboard please?

Thanks

Venki

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

You don't have to enable to see out of the box dashboards but to get the data, you need to make sure you are refreshing your aggregate measures. Go to System Admin - setup - Entity Store and refresh required measures.

Was this reply helpful? Yes No
Venki Guru 10 on at

Like (0)

Report

Hi Ajit,

Thanks for your response. The Problem we are facing is that the data in the embedded PowerBI dashboards doesn't look like it is coming from the production system, the number are wierd and are no were near reality. So we are thinking that the system is not connected to the Production Database.

Also is there a way to know what are the calculations behind the dashboard information for Finance, Sales, Procurement, Inventory, Warehouse etc.?

Thanks

Venki

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

Hi Venki - Yeah that's why I was saying to check if aggregate measures are scheduled to refresh or not. If not, you can go to entity store and refresh them. And to check calculation, aggregate measures are made by entities, tables or views. You can go to AOT in VS and look for Aggregate Measures under Analytics. For example 'FinancialReportingTransactionData' measure is for finance transactional data.

Was this reply helpful? Yes No
Venki Guru 10 on at

Like (1)

Report

Thanks a lot Ajit will try this and let you know. Appreciate your time and advice.

Was this reply helpful? Yes No