Adding powerbi report to BI Book requires correct access and PowerBI embedded capacity. Using the tenant URL here: Power BI Sign in You can login to PowerBI service environment 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
In BI Book the report can be added by clicking here:
This opens this kind of po-up:
Add the url to the "Report URL" section