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

This is crazy valuable. Thank you.

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

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!

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 ?

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

This should be a part of the interface. No need for a command let.

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?

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

Great work Adam!

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

Excellent thanks Adam, it's like you read my mind. Thanks

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

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

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?

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?

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 ?

How to get data for all users by groups/workspaces and their activities? can a non admin guy do that with -scope/organization?

Hi Adam, How can we achieve this without user interaction?

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.

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

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.

Hi, Am not an admin to my organization. But as a developer having pro license, i tried executing the same set of code as you have explained in the video. Even after logging in using Login-PowerBIServiceAccount, when i execute next set of statements to get workspaces. Powershell ISE is still throwing an error saying " Login first with Login-PowerBIServiceAccount". Please help if am missing something here. Thanks in advance!

Hey Guys, Why not take advantage of this content and continue, showing how we can extract usage metrics for all of Tenant for those who have more than 5000 rows?

Nice movie, Nice REST API, Nice PowerShell cmdlet 😄 I hope the actions for Power BI Admin on Microsoft Flow, for citizen admin with no-code. for do automation with business systems, like ERP, SFA with no-code.

What will be the problem? Login-PowerBI : The term 'Login-PowerBI' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + Login-PowerBI + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Login-PowerBI:String) [], Comma ndNotFoundException + FullyQualifiedErrorId : CommandNotFoundException

hello man. thanks for share. let me know, where is all command? i can see just a little part of your command.

Got an error stating that nuget provider is required while installing PowerBIMgmt module....how to fix it?

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

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?

How can I get a list of gateway status?

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 ?

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?

Hi adman ,can you able to explain how to add a user in powerbi group with post commnad

Here's how to get the gateways: Invoke-PowerBIRestMethod -URL '/gateways' -Method Get

Great idea, but......these modules have failed to install on every machine I've tried

Getting the following error when trying the install command PS C:\windows\system32> Install-Module -Name MicrosoftPowerBIMgmt Install-Module : The term 'Install-Module' is not recognized as the name of a cmdlet, function, script file, or operabl e program.

Hey, is there anyway to delete the rows from a Streaming Dataset with "Historic Data Analysis" on before pushing the data with the Invoke -RestMethod ? Thanks!!

Is it possible to copy workspace into new workspace?

When I run this command: Get-PowerBITable -DatesetId [my dataset id here] I keep getting error: Get-PowerBITable Operation returned an invalid status code 'NotFound'. Can someone please assist? I can run Get-PowerBIDatasource -DatasetId [my dataset id here], without error

I must confess I don't know much about Admin side. It would be nicer to have a nice easy to use GUI please :-)

I was wondering. How can we get list of all the user whom we have given the power BI licenses? It could be a pro/free. Thanks in advance 😊

Hey Adam, how do we find the Gateways in our organization?! 🤪😂

After watching this, I still don’t know if I need admin creds or not. 🤦

Nice job Adam, this is great news. I'm getting an error when trying to use the cmdlets Import-Module : Could not load file or assembly 'netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. Reference assemblies should not be loaded for execution. They can only be loaded in the Reflection-only loader context. (Exception from HRESULT: 0x80131058) At line:1 char:1 + Import-Module MicrosoftPowerBIMgmt.Profile + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], BadImageFormatException + FullyQualifiedErrorId : System.BadImageFormatException,Microsoft.PowerShell.Commands.ImportModuleCommand Do you know how I could go about fixing this problem? do I need to run PS Core instead of 5.x?

Hey guyincube. It is so great to connect with powershell to operate in code. However it is not worthy if you can't automate it. I have been trying to connect and search the problem in google and I couldn't find a solution. I can't find a way to connect using cmdlets and interact with the api using a different login than the one you write manually your ad credentials. I always get "One or more errors occurred power bi powershell". This is my actual code: $secpasswd = ConvertTo-SecureString "SecretKey registerd app" -AsPlainText -Force $mycreds = New-Object System.Management.Automation.PSCredential ("clientId / AppId", $secpasswd) Login-PowerBIServiceAccount -ServicePrincipal -Credential $mycreds -Tenant "TenantId" $headers = Get-PowerBIAccessToken Invoke-RestMethod -Headers $headers -Uri 'api.powerbi.com/v1.0/myorg/datasets' -Method Get What I am doing wrong?