Power view is not supported in this edition of reporting services

I see this error from time to time, usually when you try to create a Power View report from the data connection you get the error that Power View is not support in this edition of reporting services.

Very self explanatory, its the edition of reporting services that was installed on the SharePoint Farm for Integrated mode that’s wrong. The requirements Business Intelligence as environment is SQL Server BI edition or Enterprise edition.

Chances are when Reporting Services Integrated mode was installed, it was installed with SQL Server Standard Edition.

So how do you fix it? You can easily upgrade the edition of SQL Server installed and it will take care of the problem.

SSIS Deployment error

While deploying SSIS Packages in SQL Server 2012/2014 you receive the following error

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

ssiserror

One of the reasons is because your SSISDB is a participant in AlwaysOn high availability environment.

Resolution:

Ensure that you are deploying your packages to the Primary node, use the Listener connection name if necessary so that you can validate that you are deploying to the right node.

Currency format for SharePoint Promoted Columns

Quick tip, I had a request from one of my customers on how they can make an InfoPath promoted column show up in currency format in SharePoint. The easiest and most straight forward way is to create a calculated column and set the column type to currency. – Done

Power view error

Last night in my adventure I found a post where someone quit Microsoft BI after encountering “Sorry, something went wrong while loading the model for the item or data source ‘Connection name’. Verify that the connection information is correct and that you have permissions to access the data source.”

Powerview-Image

To save someone a headache SQL 2014 does not support analysis and visualization of multi-dimensional models using Power view in Excel 2013 it’s primarily supported in SharePoint Mode.

Migration in progress

I’ll be migrating most of my contents from Geekswithblogs in the next few days, nothing against the platform just needed a new beginning and more personalization which was a hard to get. I’ve heard great things about WordPress and I looking forward to continuous sharing of what I know. Enjoy the ride with me!!