Interact with Power BI with PowerShell
Hi All,
PowerShell is awesome command-line tool. Microsoft Team has recently released couple of Power BI APIs and PowerShell cmdlets – which will allow you to work with workspaces, dashboards, reports, datasets, and so forth in Power BI. But these cmdlets and APIs are not just limited to Administration purposes but also for other Power BI users.
Basically there are 4 general categories of users who can leverage these cmdlets:
- Power BI administrators, who must work with resources at the Power BI tenant level, such as to enumerate workspaces, dashboards, reports, and datasets, recover orphaned workspaces, or discover the data sources used in the various datasets across an entire organization.
- Power BI users, who want to manage the resources they own in Power BI, such as to create a backup of all published reports across multiple workspaces.
- Power BI developers, who need to have a quick and easy way to prototype their solutions, such as by trying out custom REST API calls in the PowerShell console without having to resort to Web-based prototyping tools and copying access tokens.
- Power BI community members, who wish to contribute to the benefit of others, such as by joining the PowerShell community for Microsoft Power BI and helping build even more cmdlets.
Find out more on details and usage here (good article by Kay Unkroth):
https://powerbi.microsoft.com/en-us/blog/working-with-powershell-in-power-bi/
Detailed and updated list of cmdlets are available in GitHub:
https://github.com/Microsoft/powerbi-powershell
Enjoy the adventure of Power BI explorations using PowerShell 🙂
Thanks, Khilit
Comments
Interact with Power BI with PowerShell — No Comments
HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>