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 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".
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?
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?
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.
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
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?
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.
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?
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.
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?
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 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
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 ?
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?
@Adam : Really amazing to see the cmdlets work and excited to try out myself. Thanks for sharing ! 👍👍
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!
This is crazy valuable. Thank you.
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 video Adam, as always! Interesting to see the Invoke command working around the app registration. Still no options for unattended auth though? :D
Excellent thanks Adam, it's like you read my mind. Thanks
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 ?
I'm having same issue
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".
Great video, do have a suggestion to execute and export PowerBI report results to a shared drive?
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?
This should be a part of the interface. No need for a command let.
Great work Adam!
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?
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.
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 ?
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
Great video Adam, one quick question is what is the difference between the Admin APIs and the PowerShell cmds?
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?
Login-PowerBI
is not recognized.. I have Install-module "MicrosoftPowerBIMgmt" already done.
Anyone else experience this ?
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.
How would I get a list of users having access to a powerbi report published on powerbi service as application?
Thank you!
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?
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.
How to get data for all users by groups/workspaces and their activities? can a non admin guy do that with -scope/organization?
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 Adam! Do you know if it is possible to find out which report / dashboard is shared and with whom is shared by PowerShell?
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.
Try the documentation maybe ?
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
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!
Were you able to solve this issue?
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
haha true :) but only gateways you are listed as an admin on.
I want to get all the users assigned to an app workspace. How can I export a list of that using cmdlets ?
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,
How can we achieve this without user interaction?
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!!
The only way i'm aware of is to cycle the historical toggle to reset the data.
How can I get a list of gateway status?
Got an error stating that nuget provider is required while installing PowerBIMgmt module....how to fix it?
Great idea, but......these modules have failed to install on every machine I've tried
Is it possible to copy workspace into new workspace?
Not yet. The blog talks about migration items coming - powerbi.microsoft.com/en-us/blog/enable-your-team-with-new-workspaces-experiences-preview/
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.
Run as Admin when opening PowerShell
I must confess I don't know much about Admin side. It would be nicer to have a nice easy to use GUI please :-)
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 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 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
C Porteous... Thanks will try & let you know if I find any problem.. 😊👏
Hey Adam, how do we find the Gateways in our organization?! 🤪😂
Hi, have you try this? :
docs.microsoft.com/en-us/rest/api/power-bi/gateways/getgateways#code-try-0
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?
After watching this, I still don’t know if I need admin creds or not. 🤦
same
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?
Hello marlucaplus did find any solution for this?...... I am also having the same requirement please let me know if u come across any solution
Hey, were you able to find a way to get the automation done?