Programatically Refresh Power Bi Desktop file and save it

[PunitPrabhu89]

i have multiple clients from whom i get data , and i have compute engine to process and get aggregated KPI file . I use that file to create Power bi report and i upload it to blob and expose it to front end and client logs in and uses it similarly its done for multiple clients , how do i automate power bi file creation to change the data , refresh and save it in local using powershell .  i dont want to user power bi service or rest api or power automate no licensing.

I tried with Powershell and python it didnt work

Kindly help

[danextian]

Hi @PunitPrabhu89 

I'm not sure if there is a software that can even do that. You can try Power Automate Desktop. 

[PunitPrabhu89]

Thank you @danextian for quick reply  , i wanted to check if its possible with power shell or python , without using power automate, power bi service or api . because using them we need license