Category Archives: Power BI

Microsoft Power Platform – How we can help automate your business processes in Dynamics 365 CRM

Innovators have an innate quality, they break down complex structures into basic elements and then, combine permutation and combinations of those elements to form another module. This leads to groundbreaking inventions, thereby ushering a wave of innovative solutions. It is an indigenous cycle that is adopted by developers and Technical Architects in order to revolutionize… Read More »

Inogic Power BI Services: Compile graphics, reporting, dashboards and many more within Dynamics 365 CRM

Microsoft keeps innovating its products and services persistently to keep abreast with the latest technologies, no wonder it is always much ahead of their competitors in the global market since ages. Its tools and products have been catering to diverse functionalities, and are extremely popular among the users. In this blog we are going to… Read More »

Different ways of Publishing Power BI reports in Dynamics 365 CRM

Introduction: In our previous blog we have seen how to create Power BI reports using Dynamics 365 connector. In order to publish Power BI report, you must have a Power BI service account associated with it. In this blog, we will see how we can add Power BI report in Dynamics CRM dashboards. Once you… Read More »

Make Power BI report using data from Azure SQL server and view in Dynamics 365

Introduction: In this blog, we will see how to show data of SQL server into Dynamics CRM. For this first, you need to connect your Power BI Desktop with SQL server. After that, we can show Power BI report into Dynamics CRM. Step 1: Register with Microsoft Power BI and by Sign in with your… Read More »

Working on Lookup field of Dynamics 365 in Power BI

Introduction: Recently, we had a business requirement to show lookup fields name in our Power BI Reports. In Power BI Lookup columns show its guid and not name. So after some research and play around we found a solution to this problem. We achieved it by using LOOKUPVALUE function. Here as you can see in… Read More »

Connect to the Power BI Using Common Data Service (CDS)

Introduction: The Common Data Service is an integral part of the Business Application Platform, providing secure cloud storage for your app data and integrating with Office 365 and Dynamics 365. Common Data Service (CDS) is one of the way to pull data from Dynamics 365. Common Data Service (CDS) enables us to easily build and extend… Read More »

How to Use Columns in a Slicer from Multiple CRM Datasets in Power BI Reports

Introduction: Microsoft Power BI is a powerful tool used for data analysis and reporting using data from different sources, for instance, Dynamics 365. Sometimes reports demand the use of a filter and recently we had a business requirement to apply a filter based on a column from two data sets. The requirement was to have… Read More »

Quickly Open Entity record from Power BI report in Dynamics 365 CRM

Introduction: Power BI is a data analysis and visualization tool which provides various controls for this such as different types of charts, slicer etc. Using these controls user can analyse and monitor organizations or business growth easily. However recently we had a business requirement where we were supposed to show the Case records in a… Read More »