Power BI PowerShell and the Admin API

The Power BI PowerShell and the Admin API allow you to quickly inventory your organization and manage workspaces and access. Forget the hastle of setting up the App registration within Azure Active Directory for API access, the Power BI PowerShell cmdlets take care of it for you. Just install and start using today!

LET'S CONNECT!

Guy in a Cube
-- Snapchat - guyinacube

***Gear***

[alethiel]

Hi Adam, you explain us at about 10:40, that you can access to a "my workspace" to export a pbix. You can indeed list all the reports in all the "my workspaces". But export this pbix does not seem to work because the -Scope Organization does not seems to apply to the Export-PowerBIReport command. Or do you another way to do it ? And you can only publish manually ?

[abhijeetghosh]

@Adam : Really amazing to see the cmdlets work and excited to try out myself. Thanks for sharing ! 👍👍

[danagelotte]

Great video, do have a suggestion to execute and export PowerBI report results to a shared drive?

[PrakashSonti]

Great job on the admin extensions! Already used these to create documentation of Workspaces and reports. Is there a way to get the share URL and their permissions?

[garycacace]

BTW - this is great stuff! Very happy to see the PowerShell command line calls make a comeback. Far superior to the original v1.0 PS commands!

[craigporteous]

Great video Adam, as always! Interesting to see the Invoke command working around the app registration. Still no options for unattended auth though? :D

[mehdifadhli]

Hello Adam Thanks for the video, I have to merge 2 Tenant Power BI, what is the strategy to do it ? there is any risks or impacts by using the cmdlet?

[mocanada]

How would I get a list of users having access to a powerbi report published on powerbi service as application?
Thank you!

[harryleboeuf]

Is it known if MS will be incorporating the Page Details in de audit logging. It is available in the usage statistics, so why not in the audit log ?

[jirineoral]

Thanks Adam for great video. I'm excited about the ability, but regretfully not skilled with PowerShell. I'll need to figure out how to rebind all reports using a connection to use different connection. Thanks. Jiri

[guavaq]

Great video Adam, one quick question is what is the difference between the Admin APIs and the PowerShell cmds?

[GustavoGiovanneRibeiro]

Hi Adam! Do you know if it is possible to find out which report / dashboard is shared and with whom is shared by PowerShell?

[cuacolobo]

I'm looking for the same cmdlets but for SSAS on-premise. I need a list of all datasets and the SQL databases they are based upon. Adam is it possible that you make a new video but for on premise? Or maybe there is another way?

[Pklot]

Hi Adam,
You mention that it's possible to add users to a certain workspace, but is there also a way to get a list of all users and groups that currently have access to a workspace?

[govindkulkarni]

Hey Adam,
This is so useful when it comes to big DW, as one might need to refresh reports only when DW is loaded and not at specific schedule time. I am designing the same process to automatically kick off refresh once DW is loaded however due to organization has setup azure intune policies, I'm not able to connect to PBI service programmatically but manually can through powershell(popup SSO). Any leads on this.

[Karenshow]

Hi, how do I created a report/ dashboard on usage of the premium workspace I owned. For example, I want to see who published there, when and usage of it, all together.

[sarithamakam]

It was a very nice video, Can I get the details for Report Name, Dataset and Last Refresh and Next Refresh details from workspace using PowerShell commands, if yes, pls let me know which command can be used?

[gayathricyanam]

I want to get all the users assigned to an app workspace. How can I export a list of that using cmdlets ?

[NickBotha]

Login-PowerBI
is not recognized.. I have Install-module "MicrosoftPowerBIMgmt" already done.
Anyone else experience this ?

[pbunyon]

Hi GIAC... I have a huge hole in this area... I'm only a capacity admin, not service or global admin.. so am I stuck ? Also.. I really need the share/security membership data... can you expedite getting these functions to us capacity admins ?