As we all know, Power BI is a great tool for generate reports. Best part is, it allows you to consume data from various data sources. Dynamics CRM is one of those many sources. True that CRM already provide reporting capabilities, but with Power BI, you can extend that capability. For instance, you can provide more interactive Dashboards with Power BI. Here, I am going to explain how to establish a connection to your CRM 2016 on premise via Power BI desktop. Let’s follow the steps.
First click on the “Get Data” from the ribbon, and select “Odata feed” from the drop down menu. (more…)