Power BI Report Server–August 2018 Update

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 gives the Bar/Line chart combo the ability to have a solid line for one measure with a dotted line for separate measure. This increases the focus of the visual at first glance for an end user.     2.  Themes seemed to…

Read More Read More

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

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 share Report BI reports within the domain. Report Services has been around for a long time and adding these reports will enable the use of SSRS (now PBIRS) for a long time to come. Relative Date Slicer This is a pretty neat…

Read More Read More

Power BI On Premise – Full Screen

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 report.   Someone on an email chain suggested full screen option, which should be implemented. But, someone had an idea. Add ‘?rs:embed=true’ to the URL – http://DEVPBIRS:80/Reports/PowerBI/AdventureWorksDashboard?rs:embed=true .     So, if the end user wants a full screen, there is a…

Read More Read More

Disabling Download Icon From Power BI Report Server

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 I saw online was to connect thru SQL Server Management Studio (SSMS) and connect to the Reporting Services Instance – .\PBIRS. here what I get in Dev and prod. You can connect to the instance by specifying the Report Server web link:…

Read More Read More

Power BI – Edit Query

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 queries in regular reports run everyday. We wanted to do this to find out the columns and tables used in reports. What happen was they asked to edit the query to add columns. In the new Power BI and Analysis Services 2017,…

Read More Read More

SQL Server 2017–Upgrading Reporting Services

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 the in place upgrade of the engine and/or Analysis Services (SSAS) is performed. I really like how the Product Updates and instal Setup Files screens do not even show up if everything passes.   Here is a screen from the upgrade path….

Read More Read More

OLAP Acronym returns

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 and not multidimensional cubes. Lately, OLAP has not been seen as an overall description of the tabular model. There were references to semantic model replacing cube’s data source view. It is good to see this in official Microsoft documentation. While recording or…

Read More Read More

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

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 departments I have networked with are using a Hybrid approach – new stuff not under regulation can go to Azure, but current running application reports new this option for Power BI with SSRS. Using Power BI reports with Reporting Services is a…

Read More Read More

Power BI Data

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 someone says this is a one off, try to move to a centralized database for your company. The first is a text file or Excel worksheet. The data is already in the rows and columns needed for a report someone else has…

Read More Read More

Analysis Services Series on SQLShack

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 was a Best Practices article for Dimensional Modeling and other items that help with a smooth transition to creating an SSAS database. Here is a link to that article. The flow of the articles starts with the multidimensional cube, then the next…

Read More Read More