Forum Discussion

avatorl's avatar
avatorl
Impactful Individual
5 years ago

My PowerShell script to download .pbix file from Power BI service in one click

What if I need to download .pbix file from Power BI service? I’ll need it if a report has been edited in Power BI Service or if I just want to have a version after the most recent scheduled data refresh (without refreshing it in Power BI Desktop). I can open a browser, logout from Power BI Service (if I was logged in to a wrong tenant), login, open a workspace, find my report, download a .pbix file, backup my local version of the file and replace it with the file downloaded from Power BI Service. Nothing complicated, but it takes more than just a keyboard shortcut, and I'm lazy (efficient).

 

Therefore, one more PowerShell  script based on Power BI  Cmdlets to automate my daily tasks. Just one keyboard shortcut to replace a selected local .pbix file with a copy downloaded from Power BI Service. With 2 backups created before replacing.

 

https://powerofbi.org/2021/02/12/powershell-script-to-download-power-bi-report-from-power-bi-service/

1 Reply

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support

    Hi avatorl,

     

    Yes, it's convenient.

    Power bi let's us download pbix from the UI, but we can also export it through the API.

     

    Best Regards,

    Link