In this blog article, we will explain about the new updates of Power BI related to Dropdown slicer, Matrix Conditional Formatting and Hierarchical axis. Dropdown slicer: In Slicer, earlier there were only one option to show the data i.e. list. But now we have one more option as dropdown. Means now we have two option … Continue reading Power BI new updates: Dropdown slicer, Matrix Conditional Formatting and Hierarchical axis →

In this blog article, we will explain you on how to connect dynamics 365 financials service connector inside of Power BI. Below are the steps to connect over Financial OData: Open the Power BI.com online account Select Get Data option from the bottom menu Click on the Get service option Select dynamics 365 financial from … Continue reading Dynamics 365 Financials connector for Power BI embedded →

This blog explains how to set Pagination with fixed number of rows per page with table headers repeated on every page of SSRS report. Steps: Insert a Tablix on report and set table Headers. Set Row Data for Tablix Create a “Parent Group” on Tablix by Expression as below Note: We have set number of … Continue reading Pagination in SSRS Report →

Fetch XML based SSRS reports which are deployed in Microsoft Dynamics CRM online. Case: In Report, you want to sort the Tablix date as per the date field in descending order. (In the below example “Date” column). When you deploy the report and run the report, it is observed that date order is not as … Continue reading Sorting based on Date does not work in CRM based SSRS report →

In this article, we will be going through the steps for installation of BizTalk Server 2016. Below steps are for installation of BizTalk Server (Standard Edition) 2016 with Microsoft SQL server 2016 Standard edition. The environment is Windows Server 2016 on Azure. Windows Server configuration is as below: If your computer name is longer than … Continue reading Installing BizTalk Server 2016 →

In this blog article, we will explain about the new updates of Power BI related to Date Slicer, Top N Filter and Data label improvements. In Date slicer, earlier there were only one option to show the data i.e. list. But now we have four option as before, after, between and list. Means we will … Continue reading Power BI new updates: Date slicer, Top N Filter and Data label improvements →

TIBCO Cloud Integration AX Connector is compatible with Dynamics 365 Operations. Connecting to D3fO is similar to that of Microsoft Dynamics AX. Prerequisite: Dynamics 365 Operations Development environment. TIBCO Cloud Integration Subscription. Global admin credentials in Azure: Registering ERP application in Azure. Steps: Login to TIBCO Cloud Integration URL: https://app.scribesoft.com/ Create a new connection by … Continue reading Connecting to Dynamics 365 Operations through Scribe →

Scribe Insight is widely used for Integration between On-Premise and Online Applications. (Example Microsoft Dynamics CRM online 2016 and AX 2012) Scribe is also used for data migration between CRM systems. (Example CRM 4.0 On-premise to CRM 2016 Online) Below are the list of the useful tips and tricks that can be handy while you … Continue reading Useful tips and tricks for Scribe Insight →

As a BI resource you may often be asked to design and develop SSRS reports. While these SSRS reports development is straightforward, sometime we get host of issues that irritates and create bad impression of report developer. Below is one such issue that I came across and resolution to get around it. Issue 01: When … Continue reading SSRS reports Issues and tips and tricks to get around them (Part 1) →

Prerequisite: Latest CRM Update1 version environment account (purchase account not in trial account), Power BI account Purpose of the setup: Embed Power BI tile in CRM dashboard. Procedure: Here we have a CRM Update1 purchase account where I will be demonstrating the new feature in CRM where we can embed Power BI tiles in CRM … Continue reading Add or Edit Power BI Tiles in CRM Dashboard →