Power BI Report Server–August 2018 Update

The latest release of Power BI Report Server is out. You can read more and download from here.     Some of the new features that we will use include : 1. Combo chart line styles – this…

Read More »

Power BI Report Server– 5 More Nice Features for On Premise Reports

In the first blog, a big thank you was given to Microsoft for enabling Power BI in Reporting Services. Lots of shops are still not in Azure with reporting. This option gives on premise companies a way to…

Read More »

Power BI On Premise – Full Screen

I noticed awhile back, but did not think too much about it. The viewing of Power BI Reports in Power BI Report Server has a banner, bread crumbs and menus that take some display space away from the…

Read More »

Disabling Download Icon From Power BI Report Server

I read that we can remove the Download button from the main menu of Power BI Reporting Services. This is needed to clean up the Portal and remove anything that can be confusing to users. But, the only…

Read More »

Power BI – Edit Query

Recently, we had some end users start to use Power BI for Reporting Services. Instead of trying to design a large Data Warehouse, we decided to let them enter their own queries from source data. These were similar…

Read More »

SQL Server 2017–Upgrading Reporting Services

Upgrading SQL Server to 2017 Upgrading a SQL Server instance to 2017 has some changes. The first big one has to do with Reporting Services (SSRS). The installation program no longer installs SSRS and suggests to upgrade before…

Read More »

OLAP Acronym returns

After reviewing Azure Data Architecture Guide, I noticed the label Online Analytical Database (OLAP) referenced as the description for Azure Analysis Services. I will call Azure Analysis Services AAS from here on. The AAS is using tabular models…

Read More »

Power BI – 5 Nice On Premise Features That Can Be Used Part 1

Thank you Microsoft for porting Power BI reports to SQL Server Reporting Services (SSRS). This goes along way with IT shops that are still On-Premise. There is no denying that more development is going to Azure. Some IT…

Read More »

Power BI Data

There are 3 methods I see frequently used when creating visualizations in Power BI. I would stick to a file or spreadsheet for prototyping, but diffintely move to Analysis Service for the database in a enterprise. Even if…

Read More »

Analysis Services Series on SQLShack

Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with Multidimensional Cubes as well as Tabular Models. The start…

Read More »