WEBVTT
NOTE
duration:"00:32:42.4560000"
language:en-us
NOTE Confidence: 0.885769963264465
00:00:00.070 --> 00:00:03.530
So you're here for driving permit automation to monitoring.
NOTE Confidence: 0.87249892950058
00:00:04.860 --> 00:00:22.660
That's quite a topic I didn't expect anybody to show up like maybe 5 people. I know we show up. But a lot of you were here. You did a pop quiz. On Thursday, alot of you did, it, apparently so that is done. The Prohibition Party, who was there.
NOTE Confidence: 0.862252056598663
00:00:23.700 --> 00:00:43.710
I just still here. Oh my God, nice OK done now. I want you to do the feedback forms at the end of the session. You got them, either on your chair or from when entering the room, so fill them in. Please especially fell in the little box with the text. That means a lot more than just the numbers.
NOTE Confidence: 0.829167604446411
00:00:44.500 --> 00:01:04.510
And it helps sequel bits as an organizer as well. So let's get this started. I'm young since December. Microsoft maybe for some reason, maybe because I talk way too much. I work for or dinner so Belgian Belgian and Dutch company about 2005.
NOTE Confidence: 0.877529859542847
00:01:05.300 --> 00:01:23.360
Overall consultants 18 in Belgium. We do everything from Microsoft to Java to other things like yard. I don't like well that I don't know anything about actually but I do know a little bit of Microsoft stuff. I'm solution expect for the Microsoft data and AI platform.
NOTE Confidence: 0.873584270477295
00:01:24.350 --> 00:01:44.360
And I organize user groups and confidence is I'm speaking as well. Advents one thing. I love to say. Yes, if you want to become a speaker. You can just do that start at the user will better local user group get in touch with people either hear the organizers of people you know Lok.
NOTE Confidence: 0.8822061419487
00:01:45.150 --> 00:02:05.160
If you need a mental I'm available. There's a lot more people available as well. That will do that for free so go out. Whatever you doing, your day job. People will love hearing about it believe me. That's how I got started and I organize events, the power BI days is a free conference in Belgium.
NOTE Confidence: 0.862451493740082
00:02:05.950 --> 00:02:14.770
As a 3 day completely online webinars so you might want to turn that if you're interested in power, BI, which I suppose you are.
NOTE Confidence: 0.898293137550354
00:02:16.390 --> 00:02:36.400
Goals for today. This is always nerve racking is the thing that I'm going to talk about the thing that you actually expect so I want to convince you to just start monitoring your power. We are environments because a lot of people are not doing that, yet. I want to give you some examples of what to monitor and why.
NOTE Confidence: 0.913681447505951
00:02:37.190 --> 00:02:46.100
Wondering that and I want to give you what you need to start your Germany for automating everything that you want to Automate in your organization.
NOTE Confidence: 0.879474580287933
00:02:47.110 --> 00:03:07.120
But first I want you to take out your phone. Just take it out. Yes, we have to quest. I know I'm a Belgian guy do we have to stuff take it out because I'm going to give you a little pole in a minute. I learned that I need to say it in quite an advance because people just don't want to take the phone out for.
NOTE Confidence: 0.890887856483459
00:03:08.210 --> 00:03:28.220
What's not a goal today? Is writing codes life? To show you stuff. It takes way too long. To actually demo. This life, I'll be doing a tour of Ireland in May, where will be showing stuff like this so you might want to keep your eyes for the user group meetings and workshops that I'm doing there.
NOTE Confidence: 0.872762203216553
00:03:29.130 --> 00:03:49.140
I will not be covering all I will be coming power, BI Service. I will not be covering monitoring for power desktop. I will not be covering monitoring for the gateway and sadly enough. I will not be covering monitoring for the power BI report server. If you're interested in these topics come talk to me, I'm also writing a book on me.
NOTE Confidence: 0.882009387016296
00:03:49.930 --> 00:04:04.550
In general at driving automation with that information so if you're interested. Follow me on Twitter and I'll keep you updated. This is the moment. We take out the phone if you didn't have that in your hands yet.
NOTE Confidence: 0.895904064178467
00:04:05.630 --> 00:04:07.800
I want you to serve to slideor.com.
NOTE Confidence: 0.932667791843414
00:04:09.500 --> 00:04:13.410
And you'll be asked to give in this number 9197.
NOTE Confidence: 0.830912530422211
00:04:18.400 --> 00:04:23.710
Took took I'm going to imagine everybody went to slider.com gave in that number.
NOTE Confidence: 0.430018842220306
00:04:25.970 --> 00:04:26.680
Oh.
NOTE Confidence: 0.830806434154511
00:04:28.070 --> 00:04:35.300
See this is where demos fail because I need to press play first nice great.
NOTE Confidence: 0.495560944080353
00:04:36.240 --> 00:04:36.790
So.
NOTE Confidence: 0.901900887489319
00:04:37.870 --> 00:04:57.880
You should have different found of you describe to me, your job so that I know who I'm talking too. I want to know if you're a DBA if you do something with power shell. Maybe maybe you are doing python orjava.net. I don't know your job role does perfect as well. You can give multiple entries, so don't worry if you enter something already.
NOTE Confidence: 0.824104607105255
00:04:58.180 --> 00:05:01.890
I want to add to that, analysts yeah.
NOTE Confidence: 0.869241654872894
00:05:03.280 --> 00:05:05.720
Lot of by developers apparently that's cool.
NOTE Confidence: 0.612839102745056
00:05:07.950 --> 00:05:08.530
OK.
NOTE Confidence: 0.825478971004486
00:05:09.800 --> 00:05:10.360
Nice.
NOTE Confidence: 0.909392356872559
00:05:13.560 --> 00:05:14.680
That's quite interesting.
NOTE Confidence: 0.674459874629974
00:05:18.400 --> 00:05:22.400
Yeah, it Jedi great.
NOTE Confidence: 0.512955188751221
00:05:24.440 --> 00:05:25.100
So.
NOTE Confidence: 0.922382056713104
00:05:27.700 --> 00:05:29.630
I see some interesting stuff over here.
NOTE Confidence: 0.785780668258667
00:05:34.750 --> 00:05:36.280
Nice OK cool.
NOTE Confidence: 0.827694594860077
00:05:37.340 --> 00:05:43.160
You still entering stuff is also nice so all of you by developers.
NOTE Confidence: 0.95046854019165
00:05:44.340 --> 00:05:45.940
I have another question for you.
NOTE Confidence: 0.917550384998322
00:05:50.830 --> 00:06:03.150
What does your company currently monitor I know you notice as ABI developer because you're always complaining about stuff that goes too. Slow of stuff that just doesn't do what you wanted to do.
NOTE Confidence: 0.828376710414886
00:06:05.810 --> 00:06:10.760
OK, the database doesn't portent you probably checked out SQL sentry here or DB watch.
NOTE Confidence: 0.861071348190308
00:06:11.660 --> 00:06:15.300
If not you should have they still here, so we have time?
NOTE Confidence: 0.827060043811798
00:06:16.720 --> 00:06:26.360
OK, so a couple of you are monitoring power. BI I should've made a split between on power BI on premises and the service, too late.
NOTE Confidence: 0.820855736732483
00:06:28.330 --> 00:06:29.750
It's cool, yeah.
NOTE Confidence: 0.816035628318787
00:06:32.470 --> 00:06:35.580
So about a fifth of you have monitoring power BI.
NOTE Confidence: 0.898793995380402
00:06:38.680 --> 00:06:41.370
Let's go to the next path the last question.
NOTE Confidence: 0.876105904579163
00:06:42.840 --> 00:06:47.180
If you're not monitoring power BI at what are the reasons.
NOTE Confidence: 0.89165461063385
00:06:48.280 --> 00:07:00.030
Didn't you know it could be done. Maybe you'd be surprised at how many times. I hear that can you monitor the power BI service some admins now that the admin portal the usage report for example?
NOTE Confidence: 0.539420783519745
00:07:02.600 --> 00:07:03.050
OK.
NOTE Confidence: 0.880294859409332
00:07:06.150 --> 00:07:15.400
Oh, if you answered all the reason I'd love to read your feedback afterwards. You can do that through the question tab in the app on the website.
NOTE Confidence: 0.890657544136047
00:07:16.830 --> 00:07:19.080
Can get access to the data that's classic one?
NOTE Confidence: 0.632273197174072
00:07:20.060 --> 00:07:20.560
OK.
NOTE Confidence: 0.923750221729279
00:07:21.600 --> 00:07:26.020
So it looks like a reach my target audience here. I didn't know it could be done.
NOTE Confidence: 0.892087936401367
00:07:27.030 --> 00:07:35.430
Remember if you put in another reason just give me the feedback so I can improve the session as well. That's lovely.
NOTE Confidence: 0.916905999183655
00:07:36.450 --> 00:07:37.870
OK, thank you.
NOTE Confidence: 0.893892228603363
00:07:40.150 --> 00:07:45.290
Onwards I used to work for this company wide world importers.
NOTE Confidence: 0.904898941516876
00:07:46.500 --> 00:08:06.510
Now, why told imports doesn't have anything to do with the Microsoft wide world importers in case you thought had completely different company and they had this case with power be. I they wanted to use power BI. They didn't know how the adoption would be they didn't know if enough users would move away from the current software, they were using and they wanted to.
NOTE Confidence: 0.891812264919281
00:08:07.300 --> 00:08:27.310
Data that they wanted to see which report's are the most most used which developers are the most active in our cases. They wanted to see if there were any compliance issues. If people were accessing data that they shouldn't be accessing now there are a lot of other ways to go about that.
NOTE Confidence: 0.87064516544342
00:08:28.100 --> 00:08:47.730
Security for example, but still I gotta question I jumped on it, and they wanted to do. The Devops Well, you know, Devils for most people that just means they want to Automate. Everything doesn't mean exactly what devops means but still, they want to automate stuff I love that.
NOTE Confidence: 0.851284205913544
00:08:48.740 --> 00:09:08.320
So they knew about this box of all of the power BI Service. The usage metrics pain in the administrator portal. They knew they were this nice cool reapers in there with all the users which use are the most active, which data sets for the most active.
NOTE Confidence: 0.830967605113983
00:09:09.240 --> 00:09:29.250
They knew of this, but still, they wanted more. Microsoft gave him a little bit more now you can actually go and view usage metrics report data set which is nice of hero hero radical days ahead. He made this block post disk.
NOTE Confidence: 0.89543092250824
00:09:30.040 --> 00:09:39.550
But you can do with the dogs metrics. I won't go in that right now because that is too limited for what we want to reach for what we want to do.
NOTE Confidence: 0.871310472488403
00:09:41.060 --> 00:10:01.070
We want to do more and ordered locks come to the rescue, So what is logged in there. This isn't official Microsoft stuff? This is what I think is logged in there? How I classify the stuff and this might help you as well. When you go on your journey as you will soon learn.
NOTE Confidence: 0.86627858877182
00:10:01.390 --> 00:10:21.400
This is some daily activity items locked well, we have the logging off who created ABS of the person who's deleting stuff with updating stuff who's editing of viewing stuff that's nice cool. What can you use that for that's the first thing II have the by developers asking me?
NOTE Confidence: 0.865221798419952
00:10:22.190 --> 00:10:35.690
World imports so you can actually see who's been using power BI? What departments and what licenses do. They have are they using normal licenses and should we maybe be updating them to approve a license?
NOTE Confidence: 0.882687866687775
00:10:38.240 --> 00:10:57.090
You can see who is active you die a tenant you can actually measure. Which of our employees of people are the most active in power, BI and maybe have some manager at 5 in the report. All the time or you have some TV screen with a report on refreshing all the time.
NOTE Confidence: 0.864327251911163
00:10:58.360 --> 00:11:18.370
You can find it out here easily and you can segment that with your own data that you already have any of company. You can see who are actually creative and who are consumers of our Reebok. Sardasht box and next. You can also see who is he using para meters and who is using data flow and those are probably.
NOTE Confidence: 0.862880885601044
00:11:19.160 --> 00:11:39.170
But you want to have a chat with to help you evangelize power BI within the company. Well, who doesn't use apps that maybe I still see a lot of people who are unaware of what abscess and they just go? How have this report. In my workspace and works well and I have some report shared with entire.
NOTE Confidence: 0.846531927585602
00:11:39.960 --> 00:11:51.910
In a shared workspace and that's fine and they have no clue about apps. So you can find out Twitter declaw who doesn't use apps yet and you can educate them into using it.
NOTE Confidence: 0.897813379764557
00:11:53.210 --> 00:12:05.510
You'd be surprised at how many times this comes up. Somebody deleted the report's in a common workspace where everybody has added hides well who did it, nobody wants to raise their hands.
NOTE Confidence: 0.888482093811035
00:12:06.480 --> 00:12:26.490
Find it out to the audit log and one of the more important things for actually finding out the for actually getting out of the auto clock is finding out who is using? What and if you see a lot of usage and certain areas. You know, maybe we should move this.
NOTE Confidence: 0.837231695652008
00:12:27.280 --> 00:12:47.290
To our share server or maybe should improve the process get a data gateway in there. Maybe we should actually move this entire data set or actually develop double ASSESW Cube or SSS develop model excuse me. Maybe should develop that because it's more.
NOTE Confidence: 0.947099149227142
00:12:48.080 --> 00:12:51.980
Maybe there's something else going on, you can actually find these patterns.
NOTE Confidence: 0.7952601313591
00:12:53.100 --> 00:12:55.700
So we have some admin task as well.
NOTE Confidence: 0.889710426330566
00:12:56.940 --> 00:13:16.950
Who is publishing bot? Who started the tile you'll be surprised at? How many people still have trials left and you've done it. Normally you have a fixed amount of trials and you can start one. You can extend it if you want and people who don't want to do ask for pro licenses or don't get him just.
NOTE Confidence: 0.851023197174072
00:13:17.740 --> 00:13:27.340
Easy process, they do some shadowy buy stuff and they go use the free tiles. That's the best case there are some worst cases as well.
NOTE Confidence: 0.861309885978699
00:13:28.450 --> 00:13:48.460
You can actually see who's changing Watts, who's doing stuff with dataflow and was retrieving some workspaces who is setting scheduled. Refresh is you might start running into your scheduled refashion limits and that means that you actually need to go view? Who is doing that, who is who is responsible for setting those key.
NOTE Confidence: 0.865259170532227
00:13:49.660 --> 00:14:09.670
That brings us through which users are actually publishing from the desktop and maybe you want to think about having whatever those users are doing moving that to an automated deployment pipeline. I have another session that I give about this There's a there's an actual VSTS or?
NOTE Confidence: 0.841614723205566
00:14:10.460 --> 00:14:30.470
There is no known there's an actual Azure. Devops extension that helps you automated deployment of power. BI report so you check in your report and the deployment pipeline does all the test no more fidgeting with my workspace and shared workspaces and diploid to the dev workspace.
NOTE Confidence: 0.861080467700958
00:14:31.260 --> 00:14:45.040
Workspace I don't know well it's no longer necessary. Get the automated deployment pipeline going and you can see who's not doing that, yet you can help them grow in the whole so.
NOTE Confidence: 0.838866591453552
00:14:46.480 --> 00:14:56.040
You have some premium workspaces going on. Maybe those anybody used premium here yet, I know in Belgium. It's not widespread 123.
NOTE Confidence: 0.773961782455444
00:14:57.140 --> 00:14:58.590
OK couple view nice.
NOTE Confidence: 0.887060761451721
00:14:59.570 --> 00:15:12.590
So how do you know who is still using it regularly spaces and should have been migrated to the premium workspaces find out to the audit, logging find out with all those things that I showed you before.
NOTE Confidence: 0.905735790729523
00:15:13.530 --> 00:15:28.970
You can also see who's configuring those capacities because probably you're not the only part of the administrative company and sometimes it happens. In large companies that people don't talk to each other. I'm sure that in your companies that doesn't happen at all.
NOTE Confidence: 0.894070863723755
00:15:30.050 --> 00:15:43.230
But if it does seem to happen at somebody you know at a friends works by every place now that you can actually go into the audit log and few who is changing the capacities for the deployment workspaces.
NOTE Confidence: 0.852526962757111
00:15:44.350 --> 00:15:53.570
And as I said, before who change their schedules. You can actually see this so adults. There's not a lot of Errors in the order clock.
NOTE Confidence: 0.897892355918884
00:15:54.550 --> 00:16:11.660
No idea why they should be a lot more, but there are some their security stuff at least what I classify a security stuff. You want to know who is adding access who is adding members to groups and stuff like that be cause who's mucking about with all my settings.
NOTE Confidence: 0.849769711494446
00:16:12.560 --> 00:16:32.570
Me as probably administrator I set some settings in the tenant and somebody change, it who did it. It was probably the guy who went to IT gave them a bit then go to settings change probably so who's getting data from on premises like on premises data sets, you can actually.
NOTE Confidence: 0.886414170265198
00:16:33.360 --> 00:16:53.370
Information about today to get data gateway. It was getting information from files who is importing files into power. BI and you will want to have a chat with those people to see well. Maybe the process that you're following we can improve that we can automate it was files import amusing using SSIS.
NOTE Confidence: 0.85338020324707
00:16:54.160 --> 00:16:59.650
Database in Paramus says or maybe use Azure Data Factory to import it into the cloud somewhere.
NOTE Confidence: 0.890261292457581
00:17:00.600 --> 00:17:11.170
Who downloads the file on the data security there's a lot to do about data security at least in my opinion, I hope you share my opinion.
NOTE Confidence: 0.890304923057556
00:17:12.530 --> 00:17:32.540
You want to know what is happening with your data? Which users are exporting of actually printing reportes you probably will want to have a chat with users who are printing report. There's a lot of better ways to do Y to do the things that you just think they should be printing out for so people.
NOTE Confidence: 0.900982677936554
00:17:33.440 --> 00:17:37.630
In my experience people tend to print a report hang it on the wall.
NOTE Confidence: 0.830947995185852
00:17:38.550 --> 00:17:58.560
OK have you thought about putting a TV screen there and maybe we can put an interactive dashboard there. This crash it circulated that stuff, you should think about so migrating stuff who is configuring team capacities. That's wrong copy paste. So who's changing the schedule data set refresh is.
NOTE Confidence: 0.884223222732544
00:17:59.350 --> 00:18:01.280
Is something you should be knowing as well?
NOTE Confidence: 0.877537369728088
00:18:02.820 --> 00:18:22.830
But whatever you do with the audit log data. Do remember that as a latency of 30 minutes. So I've been asked before by the wide world imports company to actually build a real time alerts in based on some activity. That's found in the audit logs build a report real time alert that actually sends out.
NOTE Confidence: 0.85271817445755
00:18:23.620 --> 00:18:43.630
She sends open as a metal left somebody printed the report. I want to know who somebody publish to web. I want to know who I want to just undo it. It takes 20 minutes, so big company. A lot of stuff can happen in 30 minutes keep that in mind, your data is only kept for 90 days. Whatever you doing with.
NOTE Confidence: 0.907055675983429
00:18:44.670 --> 00:19:00.560
They contain sensitive data they contain usernames, they contain names of Reportes and sometimes you're not meant to see that stuff, you're not meant to see who's accessing all the HR data. For example, I know we all want to work with production data.
NOTE Confidence: 0.959160447120667
00:19:01.720 --> 00:19:03.390
Sometimes it's just not possible.
NOTE Confidence: 0.844342589378357
00:19:04.480 --> 00:19:14.850
Keep that in mind, so if you're starting to Automate as you need to set up a scheduled job. I need the model that job to export all the data from the audit logs.
NOTE Confidence: 0.913898229598999
00:19:16.020 --> 00:19:25.030
I hope by now, I've convinced you that you actually need to start monitoring because there's a lot of useful data in the audit logs.
NOTE Confidence: 0.857204020023346
00:19:26.240 --> 00:19:46.250
And you should have some examples and some of what to monitor and why you should be monitoring that if not type it in the questions and I'll get back to you so now you're probably wondering but young why? What's happening with automation well to automate all that stuff.
NOTE Confidence: 0.887790501117706
00:19:47.040 --> 00:20:07.050
Sup audit logging first we need to enable it in the tenant for now, it's still something you need to do manually. It should soon become something that happens. For every tenant automatically but for now. We do it manually. They're going to configure some permissions as well because we need special permissions for that outlook log data.
NOTE Confidence: 0.877544820308685
00:20:07.130 --> 00:20:27.140
First of all, either you run this powershell commands as an admin, obviously or use the web interface at protection dot Office 365 dot com you can also go there. Through the power BI Admin Center Admin Portal just press this button pops you over to the right page.
NOTE Confidence: 0.826781511306763
00:20:29.110 --> 00:20:30.770
Or configuring those permissions.
NOTE Confidence: 0.895429193973541
00:20:32.360 --> 00:20:35.240
It's hidden under permissions don't tell anybody.
NOTE Confidence: 0.876624166965485
00:20:36.500 --> 00:20:56.510
You need to create a whole don't use any of these default roles. They are like complete administrator compliance of stuff like that. They give you way too many permissions for what you need to do you actually create a role that specifically has some audit log data?
NOTE Confidence: 0.829324245452881
00:20:57.300 --> 00:21:17.310
Search for audit rolls out the permissions, you will find these 2 audit logs and few only audit logs important to remember is the audit logs permissions, they give you they actually give you permission to change audio settings, even on.
NOTE Confidence: 0.867033958435059
00:21:18.100 --> 00:21:28.300
So for example, on anything within your Office 365 tenant you can change permissions don't use this use view only order clocks.
NOTE Confidence: 0.349499762058258
00:21:29.760 --> 00:21:30.530
So.
NOTE Confidence: 0.828713476657867
00:21:31.770 --> 00:21:34.250
You need to configure the dollar logging.
NOTE Confidence: 0.927970886230469
00:21:35.230 --> 00:21:39.540
So either you go to this website, which is all the information that you need.
NOTE Confidence: 0.85100781917572
00:21:40.730 --> 00:22:00.740
And you need to manage those whole groups. You can do that here handing you over everything that you need those searching in the log usually looks like this, you just get an interface. You can search for stuff only related for example, and export it, but you shouldn't be doing it.
NOTE Confidence: 0.853396713733673
00:22:02.820 --> 00:22:09.240
This marked you actually will need to go to Powershell, who is used power shell before.
NOTE Confidence: 0.855681777000427
00:22:10.200 --> 00:22:30.210
Oh, I love you. My people OK cool, so power shell. This is where that you know it is already almost all of you so first of all this is the bad path you will need an exchange online license to do this, but value had ministrator global administrator.
NOTE Confidence: 0.883251130580902
00:22:31.000 --> 00:22:47.810
Development purposes, you set all of this up you put it in a job. Then you put it on a on a service account and get your global administrator to give that service account does exchange online license is well only one license.
NOTE Confidence: 0.883127748966217
00:22:48.760 --> 00:23:08.770
They will give it to you gladly believe me and if they don't want to give it to you. Tell them everything that I'm going to do is in the audit log. You can actually see what I'm doing and if they're not convinced verdant convinced. Yet they will be convinced now so it's easy enough as you see a couple of lines to just.
NOTE Confidence: 0.897010505199432
00:23:09.560 --> 00:23:18.840
So well, most of the lines, even have to just connect to the Office 365 tenant only this simple line is to export the data.
NOTE Confidence: 0.854522407054901
00:23:20.340 --> 00:23:40.350
And now you're asking well, what do I do now? Well, you export it. You'll get this nice file horrible horrendous if you want an example because your administrator won't give you permissions code, AKA Dot, Ms Slash PBI audit log there's this nice sample.
NOTE Confidence: 0.866948008537292
00:23:41.140 --> 00:24:01.150
Use you can already start building your report so that you can already try automating stuff using it. It's nice to get started. But as you see this is just one huge file with a lot of garbage and we only need this small block. This actually has the date stamp, it has that operation that is happening.
NOTE Confidence: 0.841843783855438
00:24:01.940 --> 00:24:16.460
A bit further, and in the file is a Jason file. It actually has who has done what? So you need to get this. This is where that well nice. You have this file now? What are we going to do well.
NOTE Confidence: 0.872380912303925
00:24:17.630 --> 00:24:33.970
You import the data warehouse data warehouse. I don't mind if it's in a dataflow. Maybe maybe it's an on premises. Maybe somewhere else maybe even a different database at all. You model, the data so that is nice and reusable.
NOTE Confidence: 0.843549013137817
00:24:35.000 --> 00:24:44.940
And then you start building it out. He posts on the data OK cool. You build some ripples on the data now, what happens currently going to automate stuff.
NOTE Confidence: 0.812471747398376
00:24:46.160 --> 00:24:49.830
Well, what about that automation well.
NOTE Confidence: 0.834903597831726
00:24:50.740 --> 00:24:54.140
All automation, NIST is having some data.
NOTE Confidence: 0.87255847454071
00:24:55.120 --> 00:25:15.130
And the writing scripts using the data for the hardest parts and you will notice this in just company is getting the data actually getting that sort of account set up with the permissions, exporting all the data modeling it in a nice way, so that is reusable getting it out of its ugly Jason format that will.
NOTE Confidence: 0.909029424190521
00:25:15.920 --> 00:25:20.300
That will take up 80% of your time writing scripts.
NOTE Confidence: 0.878177404403687
00:25:21.420 --> 00:25:32.070
Almost all of you do power shell, you know it's just process that you go to OK have this data, and see who is viewing all the Reposts maybe they won't pro licenses.
NOTE Confidence: 0.889727115631104
00:25:33.140 --> 00:25:53.150
Give them to licenses So what skills should you be making easy answer is it depends but you should be looking at your organizational needs? What does your organization actually needs I can tell you what you should be building I can tell you everything I did for wide world imports, but that won't help you because.
NOTE Confidence: 0.886753559112549
00:25:53.940 --> 00:26:09.520
Different needs, but these are some things that you can think about. Maybe you want to see somebody is accessing HR data over here. Some peoples over there and they have access to this app app. A maybe they should also have access to Abby.
NOTE Confidence: 0.900819718837738
00:26:10.440 --> 00:26:30.450
That's something that you can think about discuss it with the business and if they say, well. There's a smart ID, then maybe just maybe you have the power. Shell script using the power. BI API and you just give those permissions to the people who are using similar datasets similar similar reeboks.
NOTE Confidence: 0.87403392791748
00:26:31.240 --> 00:26:51.250
You can actually reschedule datasets rescheduled a refresh of the data set if you notice that datasets from one database of refreshing at all. The different moments. Maybe you want to just do it at the same time or maybe they are flashing at the same time that's hammered.
NOTE Confidence: 0.90138053894043
00:26:52.040 --> 00:26:58.510
You just want to schedule them one by one that stuff, you, you should be thinking about.
NOTE Confidence: 0.882169246673584
00:27:00.020 --> 00:27:20.030
But also look at what you're doing daily for me, automating stuff is a way to be lazy don't tell my boss. But I automate stuff just so I can be lazy and just so we can do fancy stuff that is new as well. But actually looking at what you do and your daily tasks help you to notice what?
NOTE Confidence: 0.896001040935516
00:27:20.820 --> 00:27:33.040
Meeting so you might or might not yet be using the pool guy comments. Sometimes people get annoying and I just keep spamming comment after comment. You might want to block those people.
NOTE Confidence: 0.903609275817871
00:27:34.090 --> 00:27:54.100
Just an ID I'm not saying I did this with wide world imports. But maybe you could or you could tell us to your friend to have somebody like that, so how are you going to do about implementing this first of all you should actually realize that you don't want to know that you don't really know what's happening.
NOTE Confidence: 0.858824074268341
00:27:54.890 --> 00:28:05.270
Your balls look we have this fancy sort of. As I'm unsure what's happening over there. It's just a blank space. People are going loses a Wild West?
NOTE Confidence: 0.874219834804535
00:28:06.370 --> 00:28:26.380
Then, what you do is you just take one use case. The thing that I did for wild impulse was just use rebuilt the built-in usage report so that will actually help you check what you're building is this correct because you have something that you can go back to and see if it's correct that gives you.
NOTE Confidence: 0.915997684001923
00:28:27.170 --> 00:28:29.730
Meetings that you need to do the more difficult stuff.
NOTE Confidence: 0.905950307846069
00:28:31.100 --> 00:28:48.430
And you write power shell, so you know this is just the process of 2 steps forward and one step back. You build stuff and then you notice. Oh, maybe I could do it in a different way. Maybe I can combine these cribs. Maybe I need that all the data to enhance this thing that I did just now.
NOTE Confidence: 0.925919473171234
00:28:49.380 --> 00:28:52.460
Obviously, the APIs sometimes do change.
NOTE Confidence: 0.885614216327667
00:28:53.360 --> 00:29:13.370
Since II started my my journey, but the probably I ordered log a lot has been added to it, and you will have to keep track of what happened. What changed to it? What was added and you will want to add stuff. For example, data flows if you don't jump on it, then you lose all the audit log of data.
NOTE Confidence: 0.88652640581131
00:29:14.160 --> 00:29:34.170
Who is using data flows in the organization and obviously you should go around show? Whatever you built even if it's just a small thing that you rebuild usage report showed everybody tell them well. I did this, and then take the next steps using momentum to get more time to.
NOTE Confidence: 0.865791320800781
00:29:34.960 --> 00:29:43.920
Automating based on those 3 ports, so I gave you buy what you need to actually start your automation journey.
NOTE Confidence: 0.895944774150848
00:29:45.140 --> 00:29:49.830
Not all was in these slides, I have a lot of resources at the bag as well.
NOTE Confidence: 0.84881603717804
00:29:51.030 --> 00:30:11.040
Power Shell, you don't need us 90%. If you do power shell already buy it for his colleagues have your boss by it. It's an awesome book. I had a colleague who was 60 years old. He wasn't burned out yet. He wanted to start automating.
NOTE Confidence: 0.883641004562378
00:30:11.100 --> 00:30:31.110
Stuff he has test you want to automate I gave him this book and he just ran through. It started doing one by one, I shouldn't be telling you this, but at first. Everything somebody does is horrible even what we do is horrible at first, but you activate you have people around you to learn.
NOTE Confidence: 0.867230951786041
00:30:31.900 --> 00:30:39.250
Conference to learn from so get the book get videos. Get whatever you need to start with power shell up to help your colleague start.
NOTE Confidence: 0.853353142738342
00:30:40.300 --> 00:31:00.310
Next up is monitoring these links will get you going with whatever you need to monitor whatever you want using the audit log. There was this interesting thread on Twitter recently between Melissa cows are guys that hadn't Aaron Nelson about how.
NOTE Confidence: 0.915371477603912
00:31:01.100 --> 00:31:16.090
Part in a large organization to get information out of the audit log because it becomes a bit more difficult when you work in a large organization, so check that out. You don't even need an account for those who don't have one.
NOTE Confidence: 0.87870579957962
00:31:17.120 --> 00:31:37.130
API scripting this is where the automation part is that if you want to automate anything in power. BI you will need to learn to work with that power by API. If you haven't done it. Yet just try it out yourself get a demo tenant and try playing around with it so.
NOTE Confidence: 0.858159065246582
00:31:37.920 --> 00:31:46.990
Thing is by Adam section here, he had a use case where you can actually assign a probably pro license based on the usage of people.
NOTE Confidence: 0.899768769741058
00:31:48.230 --> 00:32:08.240
If you can't get a if you can get access to anything in your organization. The global administrator doesn't want to work with you, your manager says we don't need automation show them this blog post or summarize it for them and they should be on board, it should help them.
NOTE Confidence: 0.870417594909668
00:32:09.030 --> 00:32:13.500
I put in the fund of my slide as well, sometimes people like that stuff.
NOTE Confidence: 0.932961046695709
00:32:14.660 --> 00:32:17.650
This is me, saying thank you for being here.
NOTE Confidence: 0.884054183959961
00:32:18.660 --> 00:32:38.670
I'm giving you back a little bit of your time. I'm giving you some time to ask me questions here as well. 'cause it's on Saturday. It's late already if you want to contact me afterwards take a picture of this. I'm on Twitter. I have a block you can email me and that's about it for me. Thank you for being.
NOTE Confidence: 0.823851883411407
00:32:39.460 --> 00:32:42.430
Thanks.