Integration of POwer BI with Dynamic 365

[fhassan]

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

[Greg_Deckler]

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

[fhassan]

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

Please suggest options. thank you in advance