Forum Discussion
Need to create powerbi report with visualization through API mechanism
Hi, UmeshGoti
You've built a semantic layer using the API. Then use the Power BI REST API to build the visualization. You'll need to generate an embed token to validate your API request. This token allows you to embed Power BI reports and dashboards. Use the Power BI REST API to create a report. You can specify a dataset (semantic model) that you created earlier. Once the report is created, you can add visualizations to it. This involves specifying the type of visualization (e.g., bar chart, pie chart) and the data field you want to use.
To generate an embed token:
POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/GenerateToken
To create a report:
POST https://api.powerbi.com/v1.0/myorg/reports
{
"datasetId": "your-dataset-id",
"name": "Your Report Name"
}
To add a visualization:
POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/pages/{pageName}/visuals
{
"visualType": "barChart",
"dataFields": ["field1", "field2"]
}You can learn from the following link:
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Anonymous for your quick and useful reply
as i am able to generate embed token using below api
Type : POST
URL : https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/GenerateToken
Request Body :
{
"accessLevel": "View"
}
but when i try to create report using below API
Type : POST
URL : https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports
Request Body :
{
"datasetId": "123-xyz",
"name": "Your Report Name"
}
in response it says
{
"error": {
"code": "",
"message": "No HTTP resource was found that matches the request URI 'https://wabi-south-east-asia-redirect.analysis.windows.net/v1.0/myorg/groups/{groupId}/reports'."
}
}
so when i asked to co-pilot it says like below
The error message you're encountering suggests that the endpoint you're trying to use is not supported for creating reports. As of now, the Power BI REST API does not support creating reports directly from scratch. Instead, you can create a report by importing a Power BI Desktop (.pbix) file or by cloning an existing report.
and if i use co-pilot suggested approach i can not create report dynamic, as i need to stick with the pbix template which i create in powerbi desktop
Also i am not getting idea where embed token we can use
can you please help me on this
Thanks !!!