Roland Oldengarm - Independent IT Contractor

Living in the coolest little capital Wellington, New Zealand!

Tag: provider-hosted-app

Part 2: Embed a Power BI Report in a SharePoint Site

This is part 2 of the blog post series: How to embed a Power BI Report in SharePoint. Please check Part 1, where I’ve shown how to embed a Power BI report in a provider hosted add-in. In this part I will show you how this report can be added to SharePoint as a custom web part. I’ve also improved the solution I built in Part 1, for example it’s also possible to embed an entire report, and not only one tile. All source code is on GitHub.

Continue reading

Part 1: How to embed PowerBI in a SharePoint site

One of the most requested features for PowerBI was to be able to embed it in any web application. This has now been implemented with Power BI Embedded. An excellent demo created by Microsoft can be found here. While this is a very cool feature, it is aiming at developers. Another feature request that many of our customers have is to embed reports in a SharePoint site, e.g. to display it on an intranet.

Currently there is no out-of-the-box web part to display a PowerBI report in a SharePoint site. What I am going to show you, is how to do this with a provider hosted add-in! Continue reading

How to get a Yammer Like counter on your page

We have an Office 365 portal and our client wanted to have a Yammer Like button. Alright, that’s easy! Add the Yammer Embed Like and we are done.

The client came back and said: Ah that looks good, but could you also please add the number of likes?
And there is where this blog post is about: Because it’s impossible to get the number of likes, created by the Yammer Like Embed. I have implemented a solution, without a custom database, and is working like a charm. It takes some time though…

Continue reading

How to properly embed a Yammer poll in SharePoint or Office 365

We had the requirement to embed a Yammer poll in SharePoint. This poll would be shown on the homepage of an Office 365 portal. With the Yammer WebPart deprecated, there are two options: Use the REST API, or use the Yammer Embed. We initially tried it with the Yammer Embed, but that is too limited. It only allows to display a certain feed, and has no filter options. The only way to show only one item is to use a Topic feed, and only tag one poll with that Topic. Another showstopper was that we could not apply our styling to the Yammer embed, as it’s hosted in an iframe with no options to style it.¬†It was also annoying that the user had to log in / authenticate every time the browser was closed & reopened.

On the other hand, the REST API has no official documentation around polls. It is possible to retrieve the poll(s), but officially it’s not possible to submit votes. However, I found a solution with the REST API and impersonation with a server-side stored token. This would mean that a user would not have to log in, it would always work.

There are three steps:

  1. Create a Yammer App
  2. Retrieve a test access token as a Yammer Network Admin
  3. Create a SharePoint Provider Hosted add-in, in my case I’ve chosen for MVC.

Continue reading