Solution: “An error occurred while attempting to save the report to Power BI Report Server”

Symptoms

Did you recently download a newer version of Power BI Desktop (optimized for Report Server)? The latest is August 2018 as of the writing of this post. If you’ve downloaded August and are trying to save to an outdated version of Report Server via the client application, it’ll give you this error message.

“An error occurred while attempting to save the report to Power BI Report Server.”

2018-11-27_09-55-22

And you can try going to Power BI Report Server via your browser and uploading there directly, but you’ll get this error message which is more helpful:

“We can’t save this Power BI Desktop report because either it is newer version or has component parts that are not supported.”

chrome_2018-11-27_12-34-14

Cause

This error occurs when users are trying to save a report from a Power BI Desktop version that’s newer than the version of Power BI Report Server installed on your server.

Solution

Upgrade your Power BI Report Server version to the latest available to make sure it’s compatible with users using the latest version of Power BI Desktop available. It will be backwards-compatible in case you have users still on October 2017 or March 2018.

  1. Log in to the server that hosts your Power BI Report Server
  2. Download the latest version of Power BI Report Server
    1. Go to https://powerbi.microsoft.com/en-us/report-server/
    2. Click “Advanced download options”
      chrome_2018-11-27_12-46-35.png
    3. Select your language and click “Download”
      chrome_2018-11-27_12-46-59.png
    4. Check the box next to “PowerBIReportServer.exe” and “Next”
      chrome_2018-11-27_12-47-26.png
  3. Run the downloaded .exe file and click “Upgrade Power BI Report Server”
    mstsc_2018-11-27_10-10-03.png
  4. Follow the prompts, and reboot the server when finished. This will cause a short amount of downtime.

You should now be able to access and save reports from/to the server as usual from all versions of Power BI Desktop.

 

 

 

How to change Power BI report page size

Did you know you can adjust the page size of your reports in Power BI? Each tab/page of your report can be a unique size specified by you down to the pixel. This comes in handy for creating “widget-like” visuals for embedding or for creating reports for print and optimal display on various screen sizes.

Your options are:

  • 16:9 (default)
  • 4:3
  • Cortana
  • Letter
  • Custom (in pixels)

Continue reading “How to change Power BI report page size”

Power BI: Calculate next year’s amount in previous year’s row

next year

The following is a DAX formula you can use to create a calculated column that shows “next year’s” value in “this year’s” row. You can easily adapt this to show “yesterday’s” amount or “tomorrow’s” total as well. It can be modified for days, weeks, months, etc. as long as the time measure is able to be sorted sequentially.

Continue reading “Power BI: Calculate next year’s amount in previous year’s row”

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”

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”