Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

How to Add Power BI Data to a Web Page

DZone's Guide to

How to Add Power BI Data to a Web Page

In this article, you will learn how to add some of the different data that you can get from Power BI onto a simple web page.

· Big Data Zone ·
Free Resource

Hortonworks Sandbox for HDP and HDF is your chance to get started on learning, developing, testing and trying out new features. Each download comes preconfigured with interactive tutorials, sample data and developments from the Apache community.

Last week I talked about Power BI, what it is, and some of the different services you can use with it. This week, let's add some of that data to a simple web page.

For this example, I am going to add the Google Analytics data from this website to this page.

First, log into your Power BI.

Click the get data link at the bottom left.

Click My Organization to bring up the app search box.

Power BI Google Analytics

Click the Apps tab and search for “google” in the search box. You should then see Google Analytics. Click into this and then click the Get it now button.

Log into your Google account. If you have multiple Google accounts, I found it worked best to sign out of all of them or run it in an incognito window.

Once you are signed in, you should see a list of the different Google Analytics data you have. Select the one you want to use and click Import.

Power BI will then go away and start loading the data.

Once loaded, go to Reports and select the Google Analytics that has been loaded. If you have more than one, it is a good idea to rename each one, for example, Corporate Site Google Analytics, Blog Google Analytics, so you won’t get mixed up.

In the File menu, select Publish to web and agree that you are OK for this to be made public.

You will then be given a piece of HTML code that starts with <iframe/>. Copy this onto your web page. Reload your webpage and you should see all the data.

It should be noted that while you can but the web page containing the iframe behind a login page, the data could still be accessed if you knew the URL contained within the iframe. This is why the link can be emailed and continue to work.

Hortonworks Community Connection (HCC) is an online collaboration destination for developers, DevOps, customers and partners to get answers to questions, collaborate on technical articles and share code examples from GitHub.  Join the discussion.

Topics:
big data ,tutorial ,power bi ,business intelligence ,data analytics

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}