Forum Discussion

avatorl's avatar
avatorl
Icon for Impactful Individual rankImpactful 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
    Icon for Community Support rankCommunity 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