Custom themes in Power BI Report Server (PBIRS)

newtheme

Power BI Report Server (as of the time of this post) doesn’t allow preview features, therefore doesn’t allow custom themes (easily). But with a little work, anyone can easily “install” a custom theme for their report in PBIRS in just a few steps.

Continue reading “Custom themes in Power BI Report Server (PBIRS)”

Embedding Power BI Report Server (PBIRS) reports in SharePoint

02

If you’re on-premises and looking to embed a Power BI Report Server report in SharePoint, you’ll find it’s not as easy as O365 embeds. But it’s certainly possible; here’s how:

Continue reading “Embedding Power BI Report Server (PBIRS) reports in SharePoint”

How to create a powerful date table or DateKey in Power BI

DateKeys are essential for relative time measures. In “manage relationships” you tie the ‘DateKey'[Date] to a date field in each of your data sources. Giles Walker shared an excellent solution for a robust DateKey that includes measurements and calculations you’re sure to find useful. Here’s that same solution I’ve modified and expanded to be as useful as possible.

Continue reading “How to create a powerful date table or DateKey in Power BI”

View and share Power BI Report Server (PBIRS) reports full screen

The O365 Power BI Service has an easy “expand” icon on reports to make them full screen whereas Power BI Report Server (PBIRS) lacks that feature. We can still view reports full screen, however, using this simple trick in the URL:

Continue reading “View and share Power BI Report Server (PBIRS) reports full screen”

Use Power BI to create a dynamic/live meeting room schedule

confasched

I recently set out to create a “live” conference room schedule that could be presented constantly on an auto-refreshed screen outside conference rooms. This would replace printed schedules placed in holders outside the rooms. The following example uses a SharePoint calendar as the conference room calendar and can be refreshed constantly using Power BI’s scheduled refresh in O365 or Report Server.

Continue reading “Use Power BI to create a dynamic/live meeting room schedule”