SSRS 2014 The data processing extension used for this data source is not available. It has either been uninstalled, or it is not configured correctly.

Issue: I got this issue in the existing SP2013 Reporting Service integrated mode: All the reports failed due issues in Shared Data Sources. When Edit Shared Data source definition, the Data source type given below error and available data source types were not listed in the dropdown list:

The data processing extension used for this data source is not available. It has either been uninstalled, or it is not configured correctly.

Web part failed in OnPreRender: System.ServiceModel.FaultException`1[Microsoft.ReportingServices.ServiceContract.RsExceptionInfo]: The report server cannot process the report or shared dataset. The shared data source ‘uViewWarehouse’ for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. —> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceReferenceException: The report server cannot process the report or shared dataset. The shared data source ‘uViewWarehouse’ for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (Fault Detail is equal to Microsoft.ReportingServices.ServiceContract.RsExceptionInfo).

Resolution:

I have removed Microsoft SQL Server Reporting Services Add-In for all the WFE, APP, and Report servers but the problem exists the same.

Then I created a new SSRS Service application in Central Admin and configured service application associations with the web application. It worked for me.

Advertisement

How to disable Visual Header on PBI visuals

• File –> Options & settings –> 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… 🙂

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';

@Injectable()
export class TranslateService {
data: any = {};
constructor(private http: HttpClient) {} 
}

Update NgModule file.

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

@NgModule({
declarations: [
AppComponent
],
imports: [
BrowserModule,
HttpClientModule
],
providers: [
TranslateService
],

…
})
export class AppModule { }

 

Complete the translation service file with following code,

@Injectable()
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`;

this.http.get<{}>(langPath).subscribe(
        translation => {
          this.data = Object.assign({}, translation || {});
          resolve(this.data);
        },
        error => {
          this.data = {};
          resolve(this.data);
        }
      );
    });
  }
}

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

en.json

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

no.json

{
  "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');
}

@NgModule({
  ...
  
  providers: [
    TranslateService,
    {
      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';

@Pipe({
  name: 'translate',
  pure: false
})
export class TranslatePipe implements PipeTransform {

  constructor(private translate: TranslateService) {}

  transform(key: any): any {
    return this.translate.data[key] || key;
  }

}

Use the the title element with following block.

<element>{{ 'KEY' | translate }}</element>
ex:

<h1>
  Welcome to {{ 'TITLE' | translate }}!
</h1>



Set language runtime

Use setLand function in you component.

@Component({...})
export class AppComponent {

  constructor(private translate: TranslateService) {}

  setLang(lang: string) {
    this.translate.use(lang);
  }

}

You can add buttons to change the language.

<h1>
  Welcome to {{ 'TITLE' | translate }}!
</h1>

Language: EN Language: NO

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

 

Cheers…! 🙂

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…! 🙂

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.

 

Modules

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

Components

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.

 

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…! 🙂

 

 

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…! 🙂

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 app.powerbi.com 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…! 🙂

 

 

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…! 🙂

 

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

$w.HttpThrottleSettings

$w.Update()

Cheers…! 🙂