5
I need to bring Dynamics CRM data into PowerBI. I used Dataverse and I can't see the appointment data, but whenever I tried to get Account data, it always says: the table is empty. Actually we can see accounts from Dynamics 365 CRM front-end.
Internal Dynamics CRM support team told me that they even assign my account the System Administrator role. I still could not see the data.
Any advice?
THanks
ShaneG
Hi,
Can you please run below query in your browser instance where you have logged in to crm with your credential
ORGNAME.crm3.dynamics.com/.../accounts
Replace ORGNAME with your organizationname.
If you able to get response and could see account records then ask you internal team to remove your security role and reassign it again.
Also, create Power BI report from scracth and use multiple methods to check if you are able to get data from any other methods.
Hi
There are three ways to connect Power BI to Dynamics. You can try each of them know which works.
Comparing the three main ways to get Dynamics 365 data into Power BI | crm chart guy
If this was helpful, please check it as verified to help others finding useful information.
Welcome to this amazing community.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,584
Super User
#2
Martin Dráb
225,864
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (