cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fhassan
New Member

Integration of POwer BI with Dynamic 365

Hi,

 

I am a newbie for power BI and please note that I am a user of the system and not the admin.

 

We have our current accounting system in dynamics 365 online with multiple entities.

I need to know how to get data from the tables of d365. I want a consolidated aging report.

 

Please help me how to input the Web API URL, and how to access the database.

 

At least a link that the same has been discussed.

 

Thank you

 

2 REPLIES 2
Super User IV
Super User IV

Re: Integration of POwer BI with Dynamic 365

For Dynamics 365 F&O data, I believe you need to use the Common Data Service. The Dynamics 365 connector I've only used with Dynamics CRM.

https://docs.microsoft.com/en-us/power-platform/admin/data-integrator


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

fhassan
New Member

Re: Integration of POwer BI with Dynamic 365

 

Hey, I tried this URL in common data services, I am still getting an error

Capture.JPG

Capture 2.JPG

 

 

Please suggest options. thank you in advance

 

 

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors