Great video Adam, as always! Interesting to see the Invoke command working around the app registration. Still no options for unattended auth though? :D
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 ?
Also having this issue, I think the command uses GET api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportKey}/Export, which does not have a corresponding command for admin yet (No Organization scope). At the moment, it seems only possible to export reports that are accessible to the user logged in. To download the reports from all workspaces you will have to add the user to these workspaces. Unfortunately this does not work with other people's "My Workspace".
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 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?
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?
Not to my knowledge. Agreed that that would be useful to have. The view report is for the actual report page and doesn't get locked every time you switch pages. Would recommend adding that to ideas.powerbi.com
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.
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
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.
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?
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?
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!
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 ?
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.
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?
Yes. If you call the admin api for getting a workspace, it will list out the membership - for a new workspace only - not the old classic workspaces. This can be done with the Power BI PowerShell CMDLET - docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.workspaces/get-powerbiworkspace?view=powerbi-ps
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!!
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.
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
Hey Sohali, you can get that using the AzureAD PowerShell module. Im actually building a conference session on this but check this demo file for syntax etc: github.com/cporteou/Presentations/blob/master/Power%20BI%20and%20PowerShell/demos/Demo1-Licenses.ps1
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?