Hello everyone, in this blog we will see how to publish Power BI report to website without authentication. If you want to display a report in your website and that should be visible to non Power BI users as well then you have to do it in following way. Step 1: Create a Power BI … Continue reading How to publish Power BI report to website without authentication →

In this blog we will see how we can add data source(SQL Server) to tabular model Pre-requisite: SQL Server with AdventureWorksDW2017 database Go to Tabular Model Explorer > Data Source and Click on Data source and select Import from data sourceand it will prompt to select data source, in this case we will select SQL … Continue reading Adding Data Source to Tabular Model →

Document Map makes navigation is easy to navigate through table in SSRS In our case we have dataset which contains Product and Product Subcategory. We created the 2 parent groups on Product key and Product Subcategory key. We have to go in the Parent group(ProductCategoryKey) >Advanced > Document Map and select the column used for … Continue reading Creating Document Map in SSRS →

Problem Statement: When a user changes the owner of Lead (either because the original owner has left the company or the lead is being assigned to a new salesperson), the system changes the owner on COMPLETED activities to the new owner of the record. This is a problem because it is important that we maintain … Continue reading Entity Relationship Behavior in D365 CRM →

Hello everyone, in this blog we will see how to connect Power BI with web as a data source.We will take moneycontrol.com ‘s data source for stock market analysis and we will generate a report based on it. Step 1: Go to get data source in Power BI desktop and select web as a data … Continue reading How to use Power BI with Web Data Source →

How to avoid blank pages in SSRS reports Hi, guys in this article we will see the reasons that add blank pages in SSRS report and their solution, Body width: The body width of SSRS Report should be precise and should be maintained with following formula. Body width <= Report width – (Left margin + … Continue reading How to avoid blank pages in SSRS report →

Customers are looking for experiences when they go for shopping these days. They are not planning to use a particular store if they do not get the best experience. In contrast, if a store is providing the best service, customers are very much interested in visiting that store again. If you want to be a … Continue reading POS Receipts printing, Device connectivity issues in Microsoft D365 For Retail →

Part 1/4: Using FOR EACH Loop with KingswaySoft Connector for CRM Invoice Integration. Introduction: The SSIS ForEach Loop container will repeat the control flow task for N number of times, which is similar to Foreach loop in any programming language. This concept can be used for Integration of Header and Lines concept like Invoice. Our … Continue reading Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 1 →

Let’s say you need to create a new store with multiple registers on CPOS.   It is now possible to have a retail store with multiple registers each running CPOS and each having their own dedicated hardware.   For example: A store with two registers both running CPOS and both having their own receipt printer, … Continue reading ProTip: Running Multiple Registers on CPOS →

In this blog, I shall explain how to reset page number in footer after page break. Steps: To reset page number on footer first add page break to the element in the SSRS report in the property window by right clicking on the element. Now click on the “add page break before” checkbox. Now Go … Continue reading How to Reset Page number in footer after Page break →