API and powershell for Power Bi Administrators

Power Bi enables organisation to be more data driven by empowering every business user build there own reports. But organisations must be capable to govern this self service BI boom. So the IT administrators must be capable of handling Licencing, Capacity, Security, Governance and Regulatory requirements.

To help achieve this, last week Microsoft released  APIs, power shell and .Net sdk for power bill admins.

A general scenario: Consider you have a database which is being used by many users and is under heavy load. Obviously there would some reports which could be optimised to reduce query size. As an admin if you could trace which are these reports you could then ask the users to optimise. This can be achieved by enumerating through resources under your tenant. Click here to read about how can we enumerate and identify.

This is just one example, but you could achieve a lot more. Below are some more related resources.

https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps
https://github.com/Microsoft/powerbi-powershell
https://github.com/Microsoft/PowerBI-CSharp
https://docs.microsoft.com/en-us/rest/api/power-bi/
https://docs.microsoft.com/en-us/power-bi/service-admin-reference