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

[kushanNa]

Hi @PunitPrabhu89 

Check out this video: https://www.youtube.com/watch?v=8HSK_-1ULro . I think he is using mouse clicks to refresh a PBIX file locally. Maybe this is an old video and the current version has changed, so I’m not sure how valid it is, but you should be able to write your own Python code for mouse clicks and movements, for example : https://www.youtube.com/watch?v=cZQDO0ktnrw 

[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