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.
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.