Browsed by
Category: SSRS

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