Use Power BI in Office 365

Page update date :
Page creation date :

Open the Power BI for Office 365 site and click the Preview Now button.

Preview Now

The account registration screen is displayed, so enter the necessary items.


For user ID entry, there are input fields to the left and right of @, but you can include any name for personal use (names that have not yet been used). In general, you should put the name of the site on the right and the names of the users who will use the site on the left.

The mobile phone number input field below (enter the verification code) is a field to enter the code obtained via the mobile phone to prevent automatic registration by the machine. If you select "Text Message", you will receive a code by text mail, but depending on the model and carrier, you may not be able to use it, so in that case you will hear the code by voice phone.

If you choose to call, you'll receive a call as soon as you send your mobile phone number, so you can hear the code from the automatic voice and enter it.

ユーザーID - パスワード - 国 - 認証コード 入力

Once you have entered everything, enter the "Create Account" button.


After you create your account, you'll see the Office 365 admin center. When the page appears, wait until the list of items in the lower right corner is "No problems".

Office 365 管理センター

As an aside, when you revisit the site, you may see a screen like the one in the figure, so please follow the instructions to enter it.


Select "Users and Groups" from the menu on the left, and then click the "Display name" link in the red frame.


Check "Microsoft Power BI for Office 365" and "Microsoft Office 365 Plan E3". The "SharePoint Online (Plan 2)" check in it is duplicated in both, so please uncheck one of them.

「Microsoft Power BI for Office 365」と「Microsoft Office 365 プラン E3」

Set the location to "Japan" and click the "Save" button.


When you return to the Office 365 admin center, select Dashboard, and then select Sites in the menu above.

ダッシュボード - サイト

Click the OK button.


When you see the screen below, pause for a few minutes or so, and then refresh your browser screen.


When the screen is switched, select "Site" in the upper menu.


Select Team Site.

チーム サイトを選択

Select Site Content from the menu on the left.

サイト コンテンツを選択

Select Power BI.

Power BI を選択

Click the Add Sample button.


When you see Sample added, close the pop-up.


A sample has been added, so let's open it. The report in the red frame in the figure visualizes the medal acquisition status of each country at the Olympic Games.

Top Countries/Regions

The sample you added is a report created in Power View, and you need Silverlight to view it. If Silverlight is not installed, a link appears at the top of the view and you can click to install it.

Silverlight をインストール

As it is, some functions do not work, so click the "Enable Content" button at the top.


The screen is Excel-based, and you can select the sheet below to see more reports. Also, although I won't go into detail here, because the report is created in Power View, you can dynamically change the contents of the report by clicking on the chart.

Power View

To return to the previous screen, click the browser's back button.

Click the "Search with Power BI Q&A" link in the top right corner and try using the Power BI Q&A feature. (You've already set up Power BI, so we'll talk about the features from now on.)

Power BI Q&A による検索

In "Power BI Q&A", by entering what you want to see from among the reports registered in Power BI Q&A (PowerPivot or Power View), you can automatically select and display the best table and graph according to the contents. In addition, the text to be input corresponds to "natural language", and you can search with free-form sentences to some extent.

Now that the Olympic medals report is in Power BI Q&A, try typing medal count and press Enter. While typing, other suggestions are suggested.

medal count と入力

Displays the total number of medals in the past.


Then type medal count by year. Then, from now on, the number of medals obtained by year will be displayed as a line graph.

In addition, you can display 2-axis and 3-axis graphs and maps depending on the input contents. In this installment, we'll talk about setting up Power BI for Office 365, so we'll talk about PowerPivot and Power BI Q&A at another time.

medal count by year と入力するとグラフが表示される