Adding a new Power BI report

The report should be first added to the designated Power BI Service workspace

as adding Power BI report to BI Book requires correct access and Power BI embedded capacity. Using the tenant URL here: Power BI Sign in You can login to Power BI Service environment (workspace) which fills these conditions.

After login you can see this kind of view:

By clicking the left-hand side you can see workspace named “EXT - Your Company”

Here you can add a powerbi report by clicking “new” or “add content”:

You can also add a report from PowerBI desktop (download: Download Microsoft Power BI Desktop from Official Microsoft Download Center) Create a simple report. You need to add some tables to the report and then publish it. For getting the data you can use “get data”:

Or create calculated tables:

Example table 1: Example table = {(“This is a row”, “Still the first row”), (“This is a second row”,“data on second row”)}

Example table 2: Calendar = CALENDARAUTO()

After adding data you can create visuals from here:

Add a visual and drag your values to it from “Fields” Now save your report and publish it to powerbi service:

After adding a report you can copy+paste the url e.g.

This url can be used to add a report to BI Book either via API or UI It should be formatted like this: https://app.powerbi.com/groups/b20a6666-4444-465a-a004-bfc0b8421cb9/reports/cbb18b8a-0de1-4295-9e7b-76df8ece1fbd/ReportSection?ctid=8a34d222-11df-111-bceb-c61d6e15ec5a

💡To learn how to then add report to BI Book please check this article.