There are many different ways you can integrate with Dynamics CRM. Here I will go through some of the available options.
Web API
The Web API is a RESTful web service. It uses JSON for requests and responses. You can use Web API with JavaScript. This works both online and on premise. This is useful for connecting Power BI to Dynamics CRM.
https://yourinstance.crm.dynamics.com/api/data/v8.1/
E.g. https://yourinstance.crm.dynamics.com/api/data/v8.1/accounts/
OData
The OData endpoint is deprecated with the release of Dynamics 365, but is still available for compatibility purposes.
https://yourinstance.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/
I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.
IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.
THANK YOU, AND LET'S KEEP LEARNING TOGETHER.
CARL