Creating PowerBI Reports Programmatically Using TOM or BI Service APIs

[kamaldeepgurhan]

We have created the semantic model via TOM in BI service and used gateway to attach/refresh the data. Now need to create the dashboards/visuals/reports from the model. One way to create it manually or we can use scripts to simulate a user interaction with a web page the manual work but it is not an optimize approach.

Please could you suggest how to create .pbix file Or now .pbib file from the code.

It would be great to have some guidance with example

[bjlay20001]

Please vote on this idea

[kamaldeepgurhan]

Hi @Anonymous  I agree with you that with APIs its not possible as of now. 

Just consider this scenario, I have saved as .PBIX file as .PBIP file type to get the folder structure which contains .Report, .SemanticModel , a .PBIP file and a git reference.

Now, just thinking to perform the reverse engineering and trying to create this folder structure to get get the .PBIX file. 

Please suggest, if this looks possible OR what do you think the challanges I can face. 

[Anonymous · Accepted solution]

Hi @kamaldeepgurhan ,
Thank you for your further questions.
Based on the idea of .PBIP files and reverse engineering that you mentioned, .PBIP files are currently a new file format for Power BI projects that provides a way to save reports and semantic models in a separate folder structure designed for version control and collaborative development. PBIP files allow you to integrate a Power BI project with a version control system such as Git, where you can independently manage and modify the semantic model and report files (such as .pbir), which is useful for development teams.

Git integration with Power BI Desktop projects - Power BI | Microsoft Learn
However, reassembling the .PBIP folder structure into .PBIX files still needs to be done through Power BI Desktop. Currently, Power BI Desktop provides the ability to save such projects, but it is not fully automated and the save operation must be performed in Power BI Desktop. While you can build the .PBIP folder structure manually or through scripting, to generate the .PBIX file, you still need to use Power BI Desktop.

Power BI Desktop projects (PBIP) - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Jonvoge]

Hi kamaldeepgurhan

You might be able to do this using some of the Report Authoring API options for Power BI embedded: Report authoring overview in Power BI embedded analytics | Microsoft Learn

I am however not an expert on this topic. Perhaps the documentation can guide you in the correct direction.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Anonymous]

Hi @kamaldeepgurhan ,

Hello, thank you for your question! Currently, the Power BI REST API does not support the creation of new .pbix report files directly through code.The API is mainly used for managing existing reports (e.g. uploading .pbix files, cloning reports, modifying datasets, etc.).You can design reports in Power BI Desktop and then automatically upload and publish the report using the Power BI REST API file using the Power BI REST API. You can refer to the related API call documentation I found for you, hope it can help you solve the problem, if you have further questions or need more help, please feel free to let me know!

Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.