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.

 

 

 

SharePoint Sudoku #1

Last week I shared “SharePoint Bingo” with readers as a free download. I have another one this week, though this one is just for fun and not a training aid. But you could certainly make a competition or drawing out of it and have prizes up for grabs.

SharePoint Sudoku #1

$2.95

Category: Tags: ,

Description

You’ve heard of Sudoku, the 9×9 grid. SharePoint Sudoku is the same concept but in a 10×10 grid and uses each letter of SharePoint instead of numbers 1-9. SharePoint Sudoku is fun just for passing time, or to challenge training attendees for a prize, or just to give away as a handout.

SharePoint Sudoku is also great for occupying early session attendees while you finish setting up.

What’s included?

  • Includes SP Sudoku #1 and solution in a downloadable zip file.
  • Unlimited downloads and prints with attribution.

What is “with attribution?”

By  purchasing and receiving unlimited downloads/uses, you’re agreeing not to remove the “by Nate Chamberlain, SharePointLibrarian.com” attribution in the footer.

Appropriate usage

This is not to be posted on an external website or shared publicly in any way. By purchasing, you agree to utilize this training aid internally within your company or consulting efforts.

  • Does that mean I can share this via email with co-workers?
    • Yes, this is a great email attachment or pre-meeting handout for your early bird attendees.
  • But I can’t send it to my aunt Bertha?
    • Correct. Bertha didn’t attend your training or share your office so no sudoku for Bertha. You can certainly send her the URL to get her own download though.

Agreeing to appropriate usage is another way of saying “I understand that by sharing this publicly I would be stealing from the author. I’m a good person so I won’t do that.”

 

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

SharePoint End-User Bingo

User adoption can be tricky. But it can also be fun. In my own trainings and sessions, I try to introduce a little gamification to re-enforce learning and make traditional training processes more engaging and memorable.

I’m pleased to share my latest game, SharePoint End-User Bingo, with you. Next time you give a training or want to hold a fun contest or drawing, add some SharePoint Bingo to the festivities to re-enforce learning, spark dialogue and make SharePoint fun for end users to explore.

Acrobat_2018-11-14_08-53-50

SharePoint End-User Bingo

$2.95

SharePoint End-User Bingo is a great way to engage trainees and improve learning retention. Give your attendees something to do in a workshop, or to take back to their desk with them. Also a great way to encourage exploration of features perhaps beyond a person’s regular tasks.

Category: Tags: ,

Description

SharePoint End-User Bingo is a great way to engage trainees and improve learning retention. Give your attendees something to do in a workshop, or to take back to their desk with them. Also a great way to encourage exploration of features perhaps beyond a person’s regular tasks. What’s included?
  • Includes downloadable SP End-User Bingo
  • Unlimited downloads and prints with attribution.
What is “with attribution?” By  purchasing and receiving unlimited downloads/uses, you’re agreeing not to remove the “by Nate Chamberlain, SharePointLibrarian.com” attribution in the footer. Appropriate usage This is not to be posted on an external website or shared publicly in any way. By purchasing, you agree to utilize this training aid internally within your company or consulting efforts.
  • Does that mean I can share this via email with co-workers?
    • Yes, this is a great email attachment or printed handout for intra- or post- session engagement/follow-up
  • But I can’t send it to my aunt Bertha?
    • Correct. Bertha didn’t attend your training or share your office so no Bingo for Bertha. You can certainly send her the URL to get her own download though.
Agreeing to appropriate usage is another way of saying “I understand that by sharing this publicly I would be stealing from the author. I’m a good person so I won’t do that.”

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Durable Document Links in SharePoint Server 2016 and Online/O365

I’ve heard these mystical links called many things, whether persistent, permanent or durable, but they all mean the same thing:

Your document links will be unbreakable when changing file names or moving files because the links created for sharing/linking refer to the document by an ID instead of its common name.

But for this to work you must activate a site collection feature available only on SharePoint 2016 or later, or SharePoint Online/O365.

iexplore_2018-11-01_13-18-10

Before activating Document ID Service feature:

https://sharepointlibrarian.sharepoint.com/:w:/r/Shared%20Documents/TV%20Guide.docx?d=w5996b48071d14dc9a5fa6f01c4e763b1&csf=1&e=nBtnVp

After activating Document ID Service feature:

https://sharepointlibrarian.sharepoint.com/_layouts/15/DocIdRedir.aspx?ID=H6C7DWJ6MW7Q-1797567310-12

Continue reading “Durable Document Links in SharePoint Server 2016 and Online/O365”

Why and when you should be using relative links in SharePoint

Consider either of these scenarios:

Re-branding/Restructuring/Renaming

  • Your organization and its departments are re-structuring and changing names
  • Your IT department and content strategists decide on a new naming convention that affects your site names and URLs to access those sites OR you’re changing from http to https
  • You have hundreds (thousands?) of documents, links, content queries and script references across your sites that refer to the old URLs and are now broken

Copying Sites/Structures or Creating Templates

  • You need to create a team site template that contains default content and page designs
  • You create the template with script references, page and promoted links that are absolute
  • You have to update all of those links (some perhaps buried deep in your layouts folder) to the new site location URL unless those links are meant to call back to a different site.

Keep in mind that if a user doesn’t have access to the site or subsite library where referenced scripts are held, those scripts won’t run for that user no matter what. This can affect the look, feel, and function of the site which causes confusion and confidence issues when they call and you say “Looks fine to me!” and they have a different experience

Many of these issues and “cleanup tasks” can be avoided (for the most part) by using relative URLs instead of absolute URLs.

Continue reading “Why and when you should be using relative links in SharePoint”

The “New item” menu in modern SharePoint document libraries now allows adding templates

I happily stumbled across an update to modern document libraries I hadn’t noticed before. The modern document library “new item” menu now includes an option to “Edit New Menu” which pulls up this pane in-context:

iexplore_2018-11-02_10-54-47.png

And also includes the ability to upload a new template directly from the menu, rather than through content type settings.

2018-11-02_11-01-17.gif

Any new templates added via this method will use the default content type for that library, but provides a way to have multiple templates for a single content type.

Change a SharePoint subsite name and URL

Sometimes “Marketing” becomes “Communication” or you’ve changed a site URL naming convention so that instead of “sharepoint.mycompany.com/marketing” you’ll be shortening all department sites to something like “sharepoint.mycompany.com/mark”. Follow these steps to change the name and URL for a SharePoint subsite.

Note: If you’re trying to change the URL for a top-level site (site collection level), you’ll need to change the URL as an administrator using PowerShell.

Continue reading “Change a SharePoint subsite name and URL”