Forum Discussion
Helper IIIPayables Dashboard with Dynamics 365
Dear All,
I am assigned to create Vendor Aging Dashboard using live data from Dynamics 365 Online in Power BI. How can I get access to the data using get sources dynamics 365 Online option.
5 Replies
- Greg_Deckler
Community Champion
You need to use the web services API. It is a different URL depending on CRM or Finance and Operations but sounds like you are using Finance and Operations.
That being said, I strongly recommend that you don't do that quite honestly. You should create a database and use the options within Dynamics to export your entities out to this other database and probably setup incremental refresh. This keeps the load off of your production instance of Dynamics 365.
v-yulgu-msftMicrosoft Employee
Hi jesly_ajin,
Power BI desktop provides a built-in data connector for Dynamic 365.
7 Steps to get started with Power BI Desktop and Dynamics 365
How to Connect to Dynamics 365 Data from PowerBI Desktop
Best regards,
Yuliana Gu
jesly_ajinGreg. Thanks a lot for the response.
The reference link provided is not working.
Thanks yulgu for the links
In the links i need to get the web api linkf from Developer Resources. I am unable to navigate to that. Can you please guide me. Is some admin rights needed.
Also, i would like to connect to d365 online finance and operations web page / reports using my credentials just like we connect to any web page. is that possible?
Kindly help as i am new to d365 and power bi
- jesly_ajinPlease help.. Do let me if my question needs to be more clear
- Greg_Deckler
Sorry, the last ) did not apparently get included in the link:
If it happens again, just copy the entire line above and paste into a browser.
