› BI

Category Archives: BI

ODBC Error Scribe Insight

 Subhash Ghimire |  Leave a comment

Error in Scribe Insight: “Conversion failed when converting date and/or time from character string” when connected to SQL Adapter. When do we get this error? When we create a SQL connection using ODBC or OLEDB adapter in Scribe Insight and use the same either as Source or Target connection in Scribe DTS. What is the … Continue reading ODBC Error Scribe Insight

Migrating the attached files from Notes in CRM using SCRIBE Insight to SQL Table

 Subhash Ghimire |  Leave a comment

In CRM, when a file is attached in Notes sections, it gets stored in “Annotation” Entity. Notes with Files attached have the isDocument set to 1 and without notes to 0. Since Annotation entity contains files attached in all other CRM entities, it is determined by “ObjecttypeCode”. Example for Account ObjectTypeCode is 1. ObjectId field … Continue reading Migrating the attached files from Notes in CRM using SCRIBE Insight to SQL Table

Microsoft Visual Studio Team Foundation Server Data inside Power BI

 Prakash Kavar |  Leave a comment

In this blog article, we will explain you on how to connect Microsoft Visual Studio TFS 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 Visual Studio TFS from the list … Continue reading Microsoft Visual Studio Team Foundation Server Data inside Power BI

Moving Data from SQL Server to Excel Using SSIS

 Sachin Dabre |  Leave a comment

In this blog article, we will explain how to move data from SQL server to Excel file using SQL Server Integration Services (SSIS). For moving data from SQL Server to Excel you need to create package, to import data from SQL Server to Excel. Step 1: – Create a Project You need to create a … Continue reading Moving Data from SQL Server to Excel Using SSIS

Power BI new updates: Dropdown slicer, Matrix Conditional Formatting and Hierarchical axis

 Sachin Dabre |  Leave a comment

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

Pagination in SSRS Report

 Shailesh Wath |  Leave a comment

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

Sorting based on Date does not work in CRM based SSRS report

 Subhash Ghimire |  Leave a comment

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

Installing BizTalk Server 2016

 Subhash Ghimire |  Leave a comment

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

Power BI new updates: Date slicer, Top N Filter and Data label improvements

 Sachin Dabre |  Leave a comment

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

Connecting to Dynamics 365 Operations through Scribe

 Anjali Hemmadi |  Leave a comment

Scribe Online 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. Scribe Online Subscription. Steps: Login to Scribe Online URL: https://app.scribesoft.com/ Create a new connection by selecting the connector type as Microsoft Dynamics AX. Fill in the required details. … Continue reading Connecting to Dynamics 365 Operations through Scribe