Hi @sailochanar
Consider the following approach:
Power BI REST API and Power Automate
While the Power BI REST API is primarily designed for automating tasks within the Power BI Service (cloud), and Power Automate (formerly Microsoft Flow) can be used for automation involving Power BI, direct automation of Power BI Desktop tasks through these means is limited. However, you can automate data refreshes, publish reports, and more with these tools once your PBIX files are uploaded to the Power BI Service.
Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Learn
Create a Power Automate visual for Power BI - Power BI | Microsoft Learn
PowerShell Scripts
For certain tasks like uploading PBIX files to the Power BI Service, PowerShell scripts can be very effective. Microsoft provides cmdlets for interacting with Power BI, which can automate the process of uploading reports to the Power BI Service, although this doesn't directly manipulate Power BI Desktop.
Working with PowerShell in Power BI | Microsoft Power BI Blog | Microsoft Power BI
Python Scripts
Python can interact with Power BI Desktop files (.pbix) indirectly. For instance, you can use Python to automate data manipulation and then use Power BI Desktop to connect to the manipulated data. However, automating the Power BI Desktop interface directly (e.g., for report design) would be challenging without an official API for desktop automation.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
