How To Install And Use Windows PowerShell Cmdlets For Power BI

hello this is Greg Deckler for Enterprise DNA and today we're going to be taking a look at the Powershell commandlets for power bi how to install them and briefly how to use them including kind of the Swiss army knife uh invoking the rest API okay so to get started with the Powershell commandlets for power bi and down here to your search and you can type in the word Powershell and so Windows Powershell comes up it's an app and you can either click on the run as administrator over here or you can right click it and say run as administrator you will need to run it as administrator to install the Powershell modules commandlets successfully okay so now once you're in Powershell you need to use the install module command so install mod Dash module Dash name Microsoft power bi MGMT Microsoft powered bi management so we can hit enter there and that's going to take a couple minutes here so while that's going on we're going to come back to here and there are a number of different modules that you can see here they all roll up into the global Microsoft power bi management module that installs all of these different modules but we're working with the admin functions capacities profiles reports workspaces data and they do and there's good documentation here on how to install them and how to use them and as I mentioned if we scroll down we get to the invoke power bi rest method so there are different Powershell functions or commandlets and functions that you can use but it doesn't cover the full breadth and of the power bi rest apis so if we take a look so this is the method that you can use to run any of the power bi rest API methods so as you can see over here we have a long list of these different uh different rest API methods that you can use and they cover everything from apps the admin features to capacities dashboards data flows you name it there's a ton of them out there for working with workspaces or groups push data sets even and in just a long list of these and they're all documented and pretty well documented how to do these so if we like you know get data sets as admin you take a look at that it shows you exactly how to invoke you know that in terms of you know and what parameters to put in place and all of that all right so let's go check our Powershell all right so it's prompting us we say yes we want to install these and so now it should come up and start installing these modules for us there it goes so as you can see it's installing all of those different sub modules okay so let's hit enter here we'll have to wait a few minutes here okay so now that it's installed took a couple minutes there uh so now what we're going to do is the first thing you need to do is you need to connect to the power bi service you need to log in so we can use this connect dash power bi service account hit enter there all right so now we're connected so there we go so then we have different uh functions that you can provide so for example get power bi workspace Dash all we run that you can see back here I have a test workspace and then I have a data Mark testing workspace I'm actually connected to right here is the tenant and there's my test workspace for example uh we can do different things so we're going to actually like upload or publish a PBI expot so paste this and this command in here so new dash power bi report Dash path the path to the pbax file Dash name I give it the name Network days and then I do Dash workspace and I run another function here get dash power bi workspace Dash name test if I enter this if I hit enter on this should upload that PBX file and publish it to the service so there you can see it's added the network days data set it also has a network days import that's associated with it and come back here and so you can see it's been uploaded okay now I mentioned the invoke dash power bi rest API method so again there are functions for certain rest API methods but not all so if we go ahead and do that so this I'm getting the available features that are available I can also do an invoke uh powerbit arrest method API in order to get the users of a particular workspace there we go grab the users of this workspace right here or maybe this one was the uh the datamart one okay well that's really all there is for this video so again there's a tremendous amount of power that administrators and developers and other people can get by using these apis to automate certain processes so I encourage you to go out and try these Powershell command lists for yourself and that's all for this video hope you have a good day [Music] [Music]

Channel: Enterprise DNA

Views: 3,526

Keywords: Business sIntelligence, Data, Analytics, Data Analytics, Data Analysis, Data Culture, Power BI, Power Shell, PowerShell, Microsoft

Id: jyAVTPhsdLI

Length: 5min 13sec (313 seconds)

Published: Tue May 16 2023