Power BI Embedded: Step 3 - integrate your report using PHP and JavaScript

Using Power BI Embedded you can integrate your report in a website or web-application. To do so there are three parts you need to do:

  • Configure your Azure environment
  • Add a Power BI workspace to this environment and upload a report
  • Implement the code to generate a token and embed your report

In this last post we will zoom in on the third part. In the previous post we’ve created a workspace, uploaded our report and saved the ID’s of the workspace and the report. In this post we will use that information (in combination with the Access Key) too generate a token and embed the report.

Continue reading...

Power BI Embedded: Step 2 - Create a workspace with Node.js and add a report

Using Power BI Embedded you can integrate your report in a website or web-application. To do so there are three parts you need to do:

  • Configure your Azure environment
  • Add a Power BI workspace to this environment and upload a report
  • Implement the code to generate a token and embed your report

In this post we will zoom in on the second part. In the previous post we’ve created a Power BI Workspace Collection in Azure. We will use the Access Key of this collection to add a workspace and upload our .PBIX Power BI report.

Continue reading...

Power BI Embedded: Step 1 - Configuring Azure

Using Power BI Embedded you can integrate your report in a website or web-application. To do so there are three parts you need to do:

  • Configure your Azure environment
  • Add a Power BI workspace to this environment and upload a report
  • Implement the code to generate a token and embed your report

In this post we will zoom in on the first part: setting up your Azure environment.

Continue reading...

Power BI desktop or online?

When you are creating Power BI reports. Do you develop them online or in desktop mode? If you are doing pure self service BI for quick prototyping, it doesn't matter all that much. However, if you use live connections, you may want to use Desktop since you can easily switch between test and production servers.

Continue reading...

Moving BI to the cloud: Consider this...

While looking into the possibilities of moving my customer's BI infrastructure into the cloud, my primary question was how to handle the lack of cloud SSAS. But there's a lot more to keep in mind. Here's a few things that I think should be thought of from an architectural point of view: not only in designing your EDW architecture, but also in designing a way of work. I've summarized them below:

Continue reading...

Moving BI to the Cloud: Ditch SSAS?

Some time ago I read Chris Webb blogged "Thoughts On The Power BI Announcements At The MS Data Insights Summit", where between the lines was this rather interesting point:

For the last few years my customers have asked me when MS was going to release SSAS in the cloud and I’ve always replied that Power BI is SSAS in the cloud – it’s just tightly coupled with a front-end right now.

As I'm currently planning to migrate the entire BI architecture of one of my customers to the cloud, this made me think: can we ditch SSAS as we know it already in favor of Power BI? What are the alternatives?

Continue reading...

Security and the Enterprise Gateway

While upgrading from Analysis Services Connector to the Power BI Enterprise Gateway, you might notice a change in authorization structure. Here's a brief description of the differences you need to know when upgrading. I thought there was a change in authorization structure, but I had didn't fully understand the way Analysis Services Connector authorizes its users.

Continue reading...

Building the Poor Man's IoT

This Christmas holiday I spent some time fiddling with sensors to build a Proof of Concept on Azure IoT. In an earlier post I've shown how to connect your Azure IoT Hub data to a live Power BI dashboard, and as promised, here's part two: a description - as well as working code - how to set up your home IoT appliance for monitoring all kinds of things around your house. And because it is on private budget, I've also put a focus on affordability of the stuff. I present to you: 'The Poor Man's IoT'!

Continue reading...