Skip to content
September 4, 2019 / chinthanaronline

How to disable Visual Header on PBI visuals

  • File –> Options & settings –> Options.
  • Options
  • CURRENT FILE –> Report Settings.
  • Visual Options –> Use the modern visual header with updated styling options.
  • Then for each visual you can On / Off Visual Header with more options.
  • This will not affect in PBI desktop, but to view this login and publish to PBI workspace.

Cheers… 🙂

November 10, 2018 / chinthanaronline

Angular Translation Service

Angular Translation service is the simplest way to translate language in angular applications.

Install Translation Service

ng g service translate –module=app

This will generate the translate service file.

import { Injectable } from '@angular/core';
import { HttpClient } from '@angular/common/http';
export class TranslateService {
data: any = {};
constructor(private http: HttpClient) {} 

Update NgModule file.

import { HttpClientModule } from ‘@angular/common/http’;
import { TranslateService } from ‘./translate.service’;

declarations: [
imports: [

providers: [

export class AppModule { }


Complete the translation service file with following code,

export class TranslateService {
  data: any = {};
  constructor(private http: HttpClient) {}
  use(lang: string): Promise<{}> {
    return new Promise<{}>((resolve, reject) => {
      const langPath = `assets/i18n/${lang || 'en'}.json`;
        translation => {
 = Object.assign({}, translation || {});
        error => {
 = {};

Service will find the language file form "assets/i18n"

  "TITLE": "My i18n Application (en)"

  "TITLE": "My i18n Application (no)"

Loading locals
Complete the NgModule with following code,
import { NgModule, APP_INITIALIZER } from '@angular/core';
export function setupTranslateFactory(
  service: TranslateService): Function {
  return () => service.use('en');
  providers: [
      provide: APP_INITIALIZER,
      useFactory: setupTranslateFactory,
      deps: [ TranslateService ],
      multi: true
export class AppModule { }

Install Translation Pipe
use below CLI command
ng g pipe translate --module=app

This will create the translation pipe file,

import { Pipe, PipeTransform } from '@angular/core';
import { TranslateService } from './translate.service';
  name: 'translate',
  pure: false
export class TranslatePipe implements PipeTransform {
  constructor(private translate: TranslateService) {}
  transform(key: any): any {
    return[key] || key;

Use the the title element with following block.
<element>{{ 'KEY' | translate }}</element>
  Welcome to {{ 'TITLE' | translate }}!

Set language runtime

Use setLand function in you component.

export class AppComponent {
  constructor(private translate: TranslateService) {}
  setLang(lang: string) {

You can add buttons to change the language.
  Welcome to {{ 'TITLE' | translate }}!
Language: EN Language: NO

As a next step you can save the selected language on localstorage in browser.


Cheers…! 🙂

August 15, 2018 / chinthanaronline

Creating first Angular 6 application

This is to give you very short description how to create your first angular 6 application quickly.

Getting started

Download and install Node.js

Install TypeScript

npm install -g typescript

Install CLI

npm install -g @angular/cli

Create App

ng new myfirst-app

Run application

ng serve

Type this Url in your browser http://localhost:4200/


Cheers…! 🙂

July 1, 2018 / chinthanaronline

Introduction to Angular

What is Angular?

Angular is a platform for building client applications in HTML and TypeScript with amazing features. This is written in TypeScript. It implements core and optional functionality as a set of TypeScript libraries that you import into our apps. Basically this is build with NgModules for complile Components.



Basically there are two modules called AppModule(root module) and other custom modules which combines with services and functions.


There should be at least one component for app, this is consists with HTML template, CSS and TypeScript files. which enable to define application data and logic.


January 1, 2018 / chinthanaronline

Embed Power BI visualization with MS Office

Problem: Can I use my power BI visuals in any other office documents, such as Excel, Word and Power Point?

Resolution: Power BI Tiles Add-in is an option to add Power BI visuals to MS Office documents.

To add this Add-in you should have Power BI user account (free or pro)

  1. Open your PowerPoint slide.
  2. Go to Insert tab and click “Store”.

3. Search for “Power BI Tiles” and select the Add-in.

4.  Click Add.

5.  Click on “FROM POWER BI” and provide authentication details on web.

6.  Select the Workspace and then you can see all your existing dashborads or reports.

7.  It will show selected dasboards and reports in your Office documents as below.

8. In addition Power BI Tiles enables you to apply filters on the visuals.

Hope this will help to achieve your task.

Cheers…! 🙂



Read more…

December 10, 2017 / chinthanaronline

Sorting Charts in Power BI

Problem: Is there an option in Power BI Desktop where I can sort the chart by value in descending or ascending order? The option now is only by descending when I click the 3 dots at the top right corner.

When I click it, it will sort by value in descending way. However, if I click once again, it will disable as there is no sorting at all, instead of sorting by value in ascending.

Resolution: When you check carefully there are letters “A” and “Z”. Once you click exactly on letter “A” visual will be sorted as Ascending order and when you click on letter “Z” it will be sorted as Descending order.


Hope this will help to solve your sort issue in Power BI charts.

Cheers…! 🙂

November 12, 2017 / chinthanaronline

Getting started with Power BI

Power BI Dashboards, reports and tiles helps you to stay up to date with your information by connecting with different datasets and sharing insights with others.

Basically Power BI has free version and Pro version. If you are a new user Sign Up for Power BI or if you already have an account go to this link to access PBI services.

Power BI Desktop enables you to download and install the app on your PC.

  • Open the Power BI desktop by providing the credentials.
  • Get Data

select Get Data.

Select the data source and database or browse the data file.

Once connected to the data source. Select the data set.

  • Working with dataset

Once you have selected the data set can see all the fields in the FIELDS section.

In FIELDS section can Measures, New columns and some other actions as above image.

  • Visualization

Here you can add any charts and visuals from VISUALIZATIONS section in to the page.


Once added visual to the page you can set “Legend”, “Details” and “Values” as you can see in the above images.

  • Publish

To publish the report click on “Publish” button in the top ribbon button section.

Then select My Workspace or any other custom workspaces available and click “Select”.


Once published click on the first link to open the PBI report in web.

  • Dashboard

Click on Pin Visual.

Select New dashboard with the new name. Click “Pin”.

Now you are done with some Power BI basics.

Cheers…! 🙂



October 5, 2017 / chinthanaronline

Create bot application with bot builder

I just walk you through the Microsoft Bot Builder SDK for .NET, which provides framework to .net developers to create bot application in Visual Studio 2015 and windows 10.

Get ready for the environment.

Make sure the following prerequisites,

  • Install Visual Studio 2015/2017 with latest extensions.
  • Download the Bot Application, Bot Controller, and Bot Dialog .zip files and copy files to your Visual Studio project templates directory. (%USERPROFILE%\Documents\Visual Studio 2015\Templates\ProjectTemplates\Visual C#)


Create bot

Open Visual Studio and select the “Bot Application” and the create a new project with your bot name.

Once you created the project visual studio already contains all the required components basically the reference called Microsoft.Bot.Builder. If not check on “Manage NuGet Packages” by right clicking on the project.

Code the Bot

Template will provide you the basic methods as blow.

“Post” Method in “Controllers\MessagesController.cs” which receives messages from user and it will invokes the RootDialog.

“MessageReceivedAsync” Method in Dialogs\RootDialog.cs will process the message and response to the user. In here you can some customized codes based on your requirement.

Test the Bot

You have to download and install the Bot Framework Emulator to test and debug your bot application in localhost.

Run the Bot

After finish Emulator installation run your bot in Visual Studio using browser (Microsoft Edge) as the application and display the default.htm page in Microsoft Edge.

Now your bot is running locally, then open the Bot Framework Emulator and type below Url with port number (port number in the browser application) “http://localhost:port-number/api/messages”

Since you are still not registered the bot with any other channel leave the “Microsoft App ID” and password fields blank and click “Connect”

Now you have successfully created your bot, so now you can type any message on Emulator and It will reply with the number of characters in your message.

Cheers…! 🙂


February 7, 2017 / chinthanaronline

SharePoint: Updates are currently disallowed on GET requests. To allow updates on a GET, set the ‘AllowUnsafeUpdates’ property on SPWeb.

Problem: Initially my WSP solution is encountered an above titled error.

After play around few hours I found that, Central Administration is not allowed me to access General Settings of Web Applications by giving the error below;

  • “Updates are currently disallowed on GET requests.
  • To allow updates on a GET, set the ‘AllowUnsafeUpdates’ property on SPWeb.
  • Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: e845bd26-f70b-4f65-a023-82ca9d126031”


Cause: According to the stack trace my new web application is trying to update “HttpThrottleSettings”.


Resolution: To fix this issue I ran below PowerShell script.

$w = get-spwebapplication http://webapplicationname



Cheers…! 🙂

January 9, 2017 / chinthanaronline

Installing Kofax Total Agility (KTA) 7.0

Basically there are two options, On-Premise and Azure cloud(SaaS). Here I’m explaining On-Premise single server installation, but in production environment we have to install Web, Application and Transformations servers separately.

Installation Prerequisites

  • Hardware Requirements

Memory Recommended: 4 GB or more, Processor Speed Recommended: 2.6 GHz or faster


  • Software Requirements

SQL 2008 and above, Silverlight 5, Internet Information Services (IIS) v7 or later,

.NET Framework 4.5 or above


  • Server Operating System

Windows Server 2008 R2 and above


  • User Accounts

Installer Account (Local Administrator, Appropriate SQL Permissions)

Service Account (Local Administrator, Appropriate SQL Permissions, Log on as a Service)


 Steps to Installation

  1. To start the installation right click on Setup.exe and Run as Administrator.


  1. Make sure all these components are installed properly.



  1. Select DB server.



  1. Select server and Authentication.



  1. Import System Maps. Click Next.



  1. Installation started. During the installation it is Copying files, setting up Agility Databases, Creating Application pools, Installing Agility core services, Importing Localization files, System Maps and Transformation Designer.


  1. Provide the Serial Number and Product code.


  1. Installing Transformation Server.


  1. Setup the Transformation server

  1. Provide service account details.


  1. Enable Online Learning.


13.   Setup Reporting Connection.


  1. Make sure all the services are running.

  1. Open Designer.


  1. Open Transformation Designer.


Cheers…! 🙂