Power BI Embedded for WordPress now available!

[npnigro]

I wanted to make you aware of a plugin that Atlas Public Policy (www.atlaspolicy.com) has created to makes it easy to integrate Power BI Embedded with your WordPress website.

Atlas uses Power BI in most of our projects to make data more accessible to professionals in public policy. Often, our work includes building public-facing websites with WordPress and embedding Power BI reports using "publish to web." 

Recently, we wanted to expand our offerings and take advantage of Power BI Embedded. We figured we weren't the only ones and in the spirit of open source development, we created a plugin to connect Power BI Embedded and WordPress. For the first release, we included functionality to embed dashboards, reports, report visuals, Q&A, and tiles.

This plugin uses the Power BI REST API to access various types of content and easily embed them on a WordPress site using a shortcode. The plugin follows the "app owns data" process as documented by Microsoft here. 

The plugin relies on Microsoft's JavaScript library for embedding Power BI available on Github here: https://github.com/Microsoft/PowerBI-JavaScript.

You can download the Power BI Embedded for WordPress plugin on GitHub here: https://github.com/atlaspolicy/power-bi-embedded.

More documentation on the plugin is available in the README on GitHub. 

We would really value the contribution of others on this project to expand the plugin's capabilities and increase its usefullness to the Power BI community.

[Anonymous]

Hi

There is a way to config Power Bi Embedded for Wordpress module to work with a Custom Power Bi server Report?

Thanks

[Anonymous]

Assuming I'm understanding your question right, no, the Power BI site's url is hardcoded in several places, so it will only work with reports hosted on PowerBI.com.

Howerver, the plugin's code is public, so there's no reason you couldn't fork it and upload the plugin directly to your site.

[Anonymous]

Hello, thank you so much for this fantastic plugin. As a colleague below mentioned, how can we use RLS with this plugin? I need to restrict the content by user, it is an intranet portal.

[uday_09]

Hi Payal, Thanks for this.

Does this also have a premium version of it?

[adeelnazir786]

How can i apply RLS on Wordpress Embedded Report?

[adeelnazir786]

Hi @npnigro 

Great news for me. I'm able to connect Power BI Reports with Wordpress by following all steps

Now i want to see RLS i.e. applied on my reports. Over wordpress plugin setting i couldnt see any option to add body like we did in REST API on Power BI Embedded Playground (Below Json example).

In short: How can i apply RLS, instructions are not clear to me.

		Body:
		{
		  "accessLevel": "View",
		  "allowSaveAs": "false",
		  "identities": [
			{
			  "username": "treet@discardmail.com",
			  "roles": [
				"UserRole"
			  ],
			  "datasets": [
				"bf6bea64-e582-4848-aaa6-ef34ccbc8e34"
			  ]
			}
		  ]
		}

Please help. 

Thanks & Regards,
Adeel

[uday_09]

Thank Payal.

What more can be done with this plugin? Im looking at this for an enterprise application.

[Holguinmora]

Hi

Do you have a case or a way that works with Power Bi embed play ground - https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/?showcase=CustomLayout#?

Regards

[npnigro]

No, sorry. The source code for the plugin is available on GitHub and WordPress. 

[Holguinmora]

Npnigro hi

Do you have a web page where I can see examples on how the plug in works?

Or you have a step by step on how to embed one of the examples post in this git hub created by Microsoft?
 https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html

[Anonymous]

Thanks for this article.

I managed to embedded the report into the WordPress site successfully as an iframe.

I set the width and height to 100% of the Power BI report.  However, I find there is some kind of constrain zooming into the report.  I can't seem to zoom in and out of the report smoothly.

Does anyone has this experience?  If so what did you do to resolve this limitations.

[DennisJung]

Is it possible to explain the plugin a little bit more?

Because it doesnt work for me 🙂

[npnigro]

Can you explain the error you're seeing? I tested on a fresh website before I published the plugin. 

[DennisJung]

It just doesn't work, when i insert the code to a page, it stays blank.

 

[npnigro]

It doesn't look like the authentication worked for you. You should see something like this:

[DennisJung]

So i tried it on our live system, but i'm only getting an error message.

AADSTS65001: The user or administrator has not consented to use the application with ID '806d5478-1ee3-446a-be0e-efda48c185e4' named 'Lager'. Send an interactive authorization request for this user and resource. Trace ID: 7ef40be7-bbb2-4e8e-96ea-de91d4870800 Correlation ID: 7d8f45d3-17af-4f3f-9dc4-a297588e7a90 Timestamp: 2018-03-02 11:57:01Z

Steps i've done:

- Registered an application on https://dev.powerbi.com/apps with the basic url of our homepage

-  enter our admin account and the ID + Secret in the plug in

[npnigro]

Sorry for the trouble. It looks like you didn't do all the steps needed to register an app. See here for more information -- you have to do some work on Azure too. I recommend making another post with further questions about setting up your app. The WordPress plugin is not built to troubleshoot the setup of an app. 

[chethan]

Am getting error Please help

[v-ljerr-msft]

Hi @npnigro,

Thanks for the sharing! 

Regards