SQLSaturday Dallas #SQLSatDallas Did A Great Job!!!

The spent Saturday (6/1/2019) at another SQLSaturday. This one in Dallas, TX – #841. Since my session, Execution Plans SQL Server 2017 was the first session of the day, I plan a nice schedule of 5 sessions to…

Read More »

Power BI Performance Analyzer

Power BI has a new feature as part of the May release called the Performance Analyzer. The release notes caution that the page might be describing a feature that is not fully released, so this is a ‘look…

Read More »

Power BI Read Only XMLA endpoints–Public Preview Premium Users

Microsoft announced the Public Preview in Premium Edition for XMLA endpoints.  What does that mean? Not too long from now, you will be able to connect to Data Sets created in Power BI unloaded to the service with…

Read More »

Jan 2019 Release–Power BI Report Server

The latest release is available for Power BI Report Server. One note, make sure you have Dot Net Framework 4.6.2 installed because it is a requirement on the server. Now to the new features: Color saturation on visuals…

Read More »

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 »