WEBVTT
NOTE
duration:"00:35:17.0580000"
language:en-us
NOTE Confidence: 0.875056266784668
00:00:21.090 --> 00:00:41.100
There's a lot of use cases this will discuss them little bit later. But just a quick overview of the agenda. So we're going to begin with if my clicky works. Just have a quick look at the essentially the licensing model that power. BI has taken over the last 4 years. Sort of that history so it becomes important when we're trying to understand why.
NOTE Confidence: 0.706564366817474
00:00:41.890 --> 00:00:43.930
Approach then.
NOTE Confidence: 0.860135138034821
00:00:46.130 --> 00:01:06.140
Yeah, Alright then we can have a look at the premium features So what is it that we want to look at and how does premium work and why is it different from the current licensing model then we going to demo this is really many going to be demo. So we're actually going to spin up an embedded instance going to show how we can access. These these features and we're going to try allow to premium only.
NOTE Confidence: 0.874946296215057
00:01:06.930 --> 00:01:26.940
You know as a pro user. We just haven't been able to do then going to look at the costs costs are pretty important, especially because this is about how we can access these features on the budget and finally, we're going to look at with this sort of conclude our talk to figure out if this approach is a sustainable approach.
NOTE Confidence: 0.875511646270752
00:01:27.730 --> 00:01:47.740
We just going to use for testing scenarios, so just for the history of power. BI probably I went live in July of 2015 and when it went live. It went live with a slightly different model and what it has today. So so those who got in early in power be. I probably remember this we also had pro and we had free but free was slightly different because.
NOTE Confidence: 0.836134970188141
00:01:48.530 --> 00:02:08.540
Actually, do it only had a subset of the features that we had in improve. But the nice thing we could do is that we could share our reports and there was a bit of pushback. When that changed, but that is one of the changes that will be speaking about now.
NOTE Confidence: 0.880011081695557
00:02:09.330 --> 00:02:29.340
In June of 2016, we got power BI embedded introduced and this was a completely different sort of way of surfacing reports because everything we had done till now we had to go to powerBI.com full and this wasn't a great story for sort of Isvs. So Microsoft work and embedded they created this new.
NOTE Confidence: 0.834640622138977
00:02:30.130 --> 00:02:50.140
Set of APIs, where we could actually take these this power BI embedded and embed sort of report path within our own sort of application and then then came the change. So July 20:17. We had these licensing changes pro and free changed essentially.
NOTE Confidence: 0.863768935203552
00:02:50.930 --> 00:03:10.940
We think that pro could do with some exceptions, except for sharing so sharing is what Microsoft decided was that big enterprise feature that they were going to use it as a differentiator between free licensing and pro licensing and In addition to that new sort of licensing.
NOTE Confidence: 0.866976320743561
00:03:11.730 --> 00:03:31.740
Premium OK so probably I premium was a new way of licensing OK. We we didn't have to license every user. There was a bit of pushback from enterprises that had 10000. Users 10000 users at 10:10 dollars a month became a lot of money so premium became a new way of licensing these people.
NOTE Confidence: 0.855479717254639
00:03:32.560 --> 00:03:52.570
But she never look at how that kind of works so with our licensing option. We had these 2 new skus. The first one was simply called bones data and this is the ISV scenario. So I don't want my users to go into powerBI.com portal. I don't want to be embedded in my own local share point portal.
NOTE Confidence: 0.867233395576477
00:03:53.360 --> 00:04:13.370
I want them to service this through my app. Now we not speaking about embedded today OK. We will be using embedded but we're not using the app owns data sort of scenario. The second version is the user owns data and that is what we're going to speak in about an user owns data is when you when your users on your tenant connect to the powerBI.com.
NOTE Confidence: 0.853190243244171
00:04:14.160 --> 00:04:34.170
This is the report through that portal or perhaps through some of the embedding such a SharePoint embedding OK, So what the user owns data. We have these 2 licensing models. The first one? Is is the user licensing and use the licensing as we discussed. It comes in 2 versions. We have free and we have pro and this means that we paid.
NOTE Confidence: 0.862312436103821
00:04:34.960 --> 00:04:54.970
Well users we have the more costly essentially incur the second version is this capacity based licensing so capacity based licensing. We essentially pay for a capacity for a given duration and that's how we license and we generally don't have to license users.
NOTE Confidence: 0.870130479335785
00:04:55.760 --> 00:05:15.770
Under the capacity there are essentially 3 sort of offerings the first is traditionally what we know is premium, which are the peace cues. Currently, there's 3 piece queues there'SP. One P 2 and P 3 and these are really just governed by the size of these machines that you're purchasing. So where P one would be 8 cores with with.
NOTE Confidence: 0.812317192554474
00:05:16.560 --> 00:05:36.570
Give me AP 2 would be 16 cores with 50 gigs of memory and P 3 would be 100 gigs with 32 cores. Yeah, then we got the MCU's now. The M Skews are fairly similar to the peace cues. There also purchased through the office store.
NOTE Confidence: 0.845582902431488
00:05:37.360 --> 00:05:57.370
They do have some sort of quirks, and use cases I must admit I certainly I don't have anybody that uses an MSQ but the one that's sort of interesting is this ask you and ask you is called a because essentially we're going to purchase this capacity through and this creates a new interesting opportunity because when we buy things through zero well generally pay per minute or.
NOTE Confidence: 0.895917654037476
00:05:58.160 --> 00:06:18.170
OK and this is very different to a premium where where when we go and we're going to pay monthly but it's an annual subscription. So the problem. Most of us have when we're looking at premium capacity or trying to evaluate it is that very few of us can't afford $60,000 to evaluate a feature.
NOTE Confidence: 0.866292357444763
00:06:18.960 --> 00:06:38.970
For small companies enterprise is not a problem, but how do we? How do we prove to manage is that we need this? So I'm not ask you is? How are we going to do it so we're going to focus on these capacity models so if we have a considerable? What is in premium so as I mentioned it is dedicated capacity? Which means that we're essentially by?
NOTE Confidence: 0.868636429309845
00:06:39.760 --> 00:06:59.770
OK and because of that Microsoft really don't care. How many users. We have you need to remember that you are now responsible for the for the performance of that machine so if you have too many users on that on that report server. It's really going to be your own problem. Microsoft on on going to give you any sort of Slas when it comes to that the other curve.
NOTE Confidence: 0.870046555995941
00:07:00.560 --> 00:07:20.570
Is well we still need to pay we still need pro uses full report writers and that's going to have a little bit of an impact on our ask usage as well. But what are some of the features that we might want to use well the first is incremental refresh? Who here was in Christian Wade's talk yesterday.
NOTE Confidence: 0.861551463603973
00:07:21.360 --> 00:07:41.370
He showed how we can use incremental. Refresh to basically optimize our ETL load so. When were large corporates. We just can't afford to pull down the whole data warehouse every 8 times a day. It's just not feasible to incremental load allows us to test that sort of Delta load capacity, then we have data flows.
NOTE Confidence: 0.827834188938141
00:07:42.160 --> 00:08:02.170
Anybody who is Krista session just just now we go. He actually demo data flows alright and then finally there's a new feature called Paginated reports we probably know it as sort of SSRS reports. Patrick spoke about that yesterday. I think anybody go to Patrick session, so if you've been to.
NOTE Confidence: 0.850598096847534
00:08:02.960 --> 00:08:22.970
Then you should know what all 3 of these features are I'm going to demonstrate paginated reports just purely because I have. I have an edge case that I think pagination reports are going to be useful to me, so before we sort of go into their demo just want to look at the embedded pricing so it's just that we understand how these this cost structure might differ.
NOTE Confidence: 0.844982028007507
00:08:23.760 --> 00:08:43.770
On the first ask you that we're going to get is what is what we call in a once Q&A. One CQ has a single corn 3 gigabytes of memory now? This is not a lot and you gotta remember that that single core is going to be divided sort of 5051 for the for the front end, one for the back end. That means you got a single core that needs to render both of.
NOTE Confidence: 0.848090469837189
00:08:44.560 --> 00:09:04.570
And your data model OK, so you are not going to get away using AA once queue for generic reporting. It's fairly cheap. I've tried to do my currency conversions right. I'm from South Africa. We have a different currency and we also have we get this premium hits, Unfortunately, but
NOTE Confidence: 0.865341126918793
00:09:05.360 --> 00:09:25.370
Roughly about 500 pounds or 550 pounds for this a once Q and that is. If we ran it for 720 hours a month ago, so typical 30 day month. Alright the next skewers. The 80 SQ so again we get 2 scores. So we see this linear scaling, we've also got 55 gigs of memory that's not quite linear.
NOTE Confidence: 0.884348690509796
00:09:26.160 --> 00:09:46.170
This price that has essentially doubled now the the interesting with thing with these 2 skus is that they go into shared capacity. So, unlike the other screws are going to talk about these are going to be in general pool. So you might get a lesser performance. So if the reason you're testing premium is to test out performance you can't.
NOTE Confidence: 0.839149475097656
00:09:46.960 --> 00:10:06.970
These features it's that just not going to be representative. The next year is the 83 skew essentially it's got 4 cores 10 gigs again. We see that sort of linear scaling and then we get the a 4 and a for becomes really important because this is the logical equivalence of AP once Q Now if anybody has.
NOTE Confidence: 0.884907305240631
00:10:07.020 --> 00:10:27.030
AP one licensing skew they'll know that the price is roughly about 3 or 3700 pounds, which means that instantly that 84 option is not going to be cheaper, so if you think that you're going to run an embedded. Q and just save money that way. Unfortunately, that is not going to be an option, perhaps if you.
NOTE Confidence: 0.844483554363251
00:10:27.820 --> 00:10:47.830
83 that could be an option OK, but there is a there's a lastic work. That's probably going to hit us just now we will discuss and then we get our logical in comparison to AP 2 as well as AP 3 and again. These cues at a monthly level are more expensive than the P 2 and P 3 respectively.
NOTE Confidence: 0.891807615756989
00:10:48.620 --> 00:11:08.630
Straight off the bat is this a direct replacement or is there a way to avoid the cost. No, it's not, but there's an important feature that these things have is that they can be turned down or turned off again. Now, this is not something that we have in that P one to P 3. Skews essentially when we when we provision AP one.
NOTE Confidence: 0.886528432369232
00:11:09.420 --> 00:11:29.430
Tri-cities we off we're locked into that. I'm pretty sure Microsoft are happy for you to upgrade I'm sure that conversation to downgrade little bit harder. It's not one that I've had so I can't comment on that, but they are generally conversations that you would have directly with Microsoft OK, so if we have a look at some of the features the first thing we want to look at is this ability.
NOTE Confidence: 0.829204380512238
00:11:30.220 --> 00:11:50.230
System application so this is this sort of opones data scenario and all 3 skews support. This so if you are interested in this queue or when that Apple own data scenario, then then essentially either 3 options is going to work for you, if you're looking for to embed these contents in applications so this is.
NOTE Confidence: 0.867136538028717
00:11:51.020 --> 00:12:11.030
Here in bed or embed in SharePoint options. The premium and the M's going to give that to you, but but the askews or not, and the reason for that is that the excuse do not support free users so one of the big reasons. We go to premium is that we don't need to license all our users with pro subscriptions, we can give.
NOTE Confidence: 0.883829116821289
00:12:11.920 --> 00:12:31.930
The free license and they will be able to access this content. That's not going to happen. Unfortunately, with the SQ so you have to take that into consideration you're going to have to license every user who wants to access content in the task. You need to pro license so that is another bang, Unfortunately, so we can see these costs tracking.
NOTE Confidence: 0.847609221935272
00:12:32.720 --> 00:12:52.730
Ask you is not going to be great for that scenario again. If we want to access those sort of a sort of mobile reports and then the big sell feature to me is this ability to scale so if we were to do a very bad piece of a very bad piece of maths, essentially organization worked around 8 hours a day we could.
NOTE Confidence: 0.893375098705292
00:12:53.520 --> 00:13:13.530
Our our a for instance, for 8 hours shut it down so if any, running for a third of the day so instead of being around about $4000 it would be 1200 pounds. Sorry not dollars essentially that gives us a discount. But that would mean that you're reporting infrastructure is not available now.
NOTE Confidence: 0.883617460727692
00:13:14.320 --> 00:13:34.330
Test that might be accessible to your company, it might not be OK. But, perhaps what we could do is instead of turning it off. We could scale it from an A 422 and that you might go through scenarios like that. With this might workout cost effectively but you just need to remember that all your users are going to need pro pro license as well that is uh.
NOTE Confidence: 0.832621037960052
00:13:35.560 --> 00:13:55.570
I can't so it's just sort of a highlight of some of the features around costing really. I think most people just want to see a demo? How can I go and do this and how can I test it against it of Chris Chris law station kind of showed that feature got a lot of people excited, especially me when he was demo.
NOTE Confidence: 0.864022612571716
00:13:56.360 --> 00:14:16.370
5 minutes before was meant to do it, but essentially how we going to enable these features So what we're going to do is we're going to create a brand new embedded capacity within is. Are we going to enable the premium feature in the portal. We're going to create a workspace for the dedicated capacity. We're going to deploy paginated report now.
NOTE Confidence: 0.850043833255768
00:14:17.160 --> 00:14:37.170
In reporting services as the thing I'm going to demo and then then we're going to resize them bed capacity, including sharing how we can actually suspend, it and they will have a look at what happens to our tenant when it's once it's been paused or more importantly, our workspace once it's been posted alright so in order to stop.
NOTE Confidence: 0.846792280673981
00:14:37.960 --> 00:14:57.970
Skin by going to the portal again. So we're going to begin in the Azure Portal because that is where we, we purchased Azure resources. So instead of the power BI or the end skews where we would go through the Office 365 portal. We're going to begin in the resource portal and we're going to create a resource.
NOTE Confidence: 0.86656129360199
00:14:58.760 --> 00:15:01.650
And you're very quickly just in the search for power BI embedded.
NOTE Confidence: 0.832422494888306
00:15:02.750 --> 00:15:09.640
Again and if we search for power BI embedded. We're going to find 2 versions of power. Be I and my portals and it's not going to show it to me good.
NOTE Confidence: 0.616179168224335
00:15:11.330 --> 00:15:12.350
Yeah, but
NOTE Confidence: 0.874998509883881
00:15:13.300 --> 00:15:33.310
Now it's going to go straight through it right OK, so they there is 2 versions of power. BI embedded you want to be careful. One of the one of them is marked as deep appreciated that essentially the old version of power. BI embedded if you have created a new skew you should be on the new one. I don't even think that allow you to create an old version of power BI embedded.
NOTE Confidence: 0.870896995067596
00:15:34.100 --> 00:15:54.110
It is essentially marked as deprecated so we're going to go in and create a resource and there's a couple of options that we're going to have help to set so the first one, is the resource name. Now the resource name becomes little bit interesting. Because anything or many of the objects that we create in Azure have weird naming conventions and and the and the name.
NOTE Confidence: 0.892168045043945
00:15:54.900 --> 00:16:14.910
Is that we're not allowed to use capital letters were not allowed use spaces were not allowed to use special characters now. This is going to be inconvenient for us. Because this is this is actually the name that can be surface to the end user OK, so that it doesn't have a particularly elegant enterprise story OK. We don't have this ability to rename this capacity.
NOTE Confidence: 0.886627197265625
00:16:15.700 --> 00:16:35.710
They dev test scenario. I don't think that's really a problem, but it is something we have to remember. We are also going to choose AA subscription. So how are we going to pay this? It's not going to come in office 36 building account it is going to be part of our Azure billing. We're going to choose a resource group. We're also going to choose the capacity administrators. So who is in charge of this.
NOTE Confidence: 0.917075037956238
00:16:36.500 --> 00:16:56.510
That should be your power be administrator. We're also going to choose a location and choice of location becomes very important because you remember, there's going to be an amount of communication between the Azure capacity, and your Office 365 capacity and if those are for example, located on different continents. There's going to be a lot of back and forth communication, which could incur.
NOTE Confidence: 0.861040055751801
00:16:57.300 --> 00:17:17.310
Positive charges and then the final thing chooses a pricing tip. Now I'm going to choose and a full pricing tier and the reason for this is that reporting services does not work with anything less than a full April pricing. Alright see caveats all over the show all right, and the reason for this does make sense because essentially reporting Sir.
NOTE Confidence: 0.89170891046524
00:17:18.100 --> 00:17:38.110
And as an outer process application and you need enough resources to build to run that and if we think about back to a one skew which is only got one call. I definitely don't have enough resources to also spin up that reporting services instance. Now like any good cooking show. I'm not going to spin up a version here because that takes.
NOTE Confidence: 0.880588352680206
00:17:38.900 --> 00:17:58.910
So I already have a prepared instance and it should be under SQL bits and here you can see we got the power BI embedded application. That's running in North Europe. But it really doesn't give us a lot of options. The only thing we've got is is this ability to pause it and our ability and our ability.
NOTE Confidence: 0.840997099876404
00:17:59.700 --> 00:18:19.710
Both of which will do a little bit later, OK, so now that we've created this capacity. How do we access it within power by the way we do? That is going to come into power be are going to see that our session is expired. I'm going to close that and we've now got our power. BI tenants, but up or a sort of access and we're going to win.
NOTE Confidence: 0.861520230770111
00:18:20.500 --> 00:18:40.510
And our sort of set set a couple of settings. So I'm going to begin by going to the admin portal. If you look under the admin portal. There's a couple of options here and we're going to begin by going to capacity settings now? How do we come here before I spun up this resource or if you look at your own. You're going to find that this is an empty screen the screen.
NOTE Confidence: 0.874071657657623
00:18:41.300 --> 00:18:56.360
I realized it looks like I don't have anything OK. So we can see the 2 options for power. BI premium and the power BI embedded obviously because we spent up an embedded option. We're going to find it on the screen going to find a couple of settings.
NOTE Confidence: 0.836074471473694
00:18:57.590 --> 00:18:58.810
When it loads.
NOTE Confidence: 0.823844850063324
00:18:59.760 --> 00:19:00.990
Go to Internet.
NOTE Confidence: 0.868575394153595
00:19:02.680 --> 00:19:22.690
Internet is much better in Africa. I must say that's OK. Alright so essentially here. We can see our capacity and importantly, we can see this is the This is the name. I choose so SQL bits demo if you wanted to show that to your users. I think we should be able to choose a slightly better name. I know one of the product manager.
NOTE Confidence: 0.842591822147369
00:19:23.480 --> 00:19:43.490
There maybe he can take that as feedback OK and we can go and set a couple settings. So we're going to click on this little gear icon over here and you can see that we can't really do much from the side OK. We can so we can set the settings. But if you click on that table name. It will take us through the admin portal or the administered.
NOTE Confidence: 0.867332458496094
00:19:51.030 --> 00:20:11.040
OK, so here we got the tenant setting and we browse down. I'm not too interested in many of these options OK. We can see the current workspace is that we've assigned to it. We can also do some sort of bulk migration of existing workspaces into our setting but the thing we were interested in is this workload options so the workload option.
NOTE Confidence: 0.887816905975342
00:20:11.110 --> 00:20:31.120
And allows us to enable certain functionality so again because reported services or paginated reports as they're called here requires a percentage of the resources we can set that setting here so I've turned it on already and I'll set 20%, 20%, is the default you.
NOTE Confidence: 0.879515171051025
00:20:31.910 --> 00:20:51.920
Microsoft suggests that it could take up to 10 minutes to do this which is why I have flagged this. I have always found it to happen instantaneously OK. We can also enable data flows as well as some of the AI features which Chris demonstrated earlier, but I'm not going to do this right now, another thing you can do you also have the ability?
NOTE Confidence: 0.852800130844116
00:20:52.710 --> 00:21:12.720
The capacity from here if if needed, depending on the feature that you're going to test you also might might need to go into the 10 settings, so its particular data flows you need to enable data flows at the tenant setting level as well, OK, so we've now gone and enabled our capacity, but we don't have anything aside.
NOTE Confidence: 0.838250577449799
00:21:13.510 --> 00:21:32.320
They were going to do that is going to be given by going to workspaces and creating a new app workspace OK, so the new app workspace. All this is the old app workspace experience going to go and use the new adverse based experience I'm going to do that by going clicking try. Now we're going to need to enter a couple of objects, so the first thing is a works based name.
NOTE Confidence: 0.734835803508759
00:21:33.450 --> 00:21:36.640
I'm going to use SQL bits going into description.
NOTE Confidence: 0.877284824848175
00:21:37.850 --> 00:21:57.860
Thank you, you actually want to be slightly more descriptive than that and then this is this is where the Magic happens, OK, so we have this ability to go and use a dedicated capacity. So you can see. I've chosen to use the data capacity and then I've chosen the workspace and this is where I saying this name is going to come through exactly as I've shown it.
NOTE Confidence: 0.835282027721405
00:21:58.650 --> 00:22:18.660
May or may not be a problem to you II just wish we could form at little bit better, OK because you know business users aren't going to be particularly happy with sort of some while we can't even camel case, it can be because we can't use. We can't use capital letters so it's not going to be all that descriptive so going create that kapi.
NOTE Confidence: 0.894429862499237
00:22:19.450 --> 00:22:39.460
But it generally takes pretty quick and here you can see that we've created our capacity because this is exactly what this diamond means so this diamond means the workspace that we've just created is backed by premium capacity and and that's what we need to be able to use some of these features so in theory, we on our unable to use reporting services.
NOTE Confidence: 0.852700054645538
00:22:40.250 --> 00:23:00.260
Now reporting services is a new feature, which means that the integration isn't exactly sort of there yet, so in order to go and upload a report. I need to come into the workspace. I need to go into the files option and say, Get and essentially what I'm going to do is I'm going to upload.
NOTE Confidence: 0.833445847034454
00:23:01.050 --> 00:23:21.060
And that flat file is is going to be my audio file going to choose a local file. We're going to choose my organizational expenditure file and I'm going to upload it and it's going to upload it. And here I can see my report. You'll notice that this symbol over here is slightly different than the one we would.
NOTE Confidence: 0.872795343399048
00:23:21.850 --> 00:23:41.860
Power BI so that's how we can distinguish between the features but more importantly, we've now gone and uploaded a reporting services report and I've probably encode $1 worth of cost right now, which is I'm sure to your manager a lot more palatable than the $5000 that we could take as well. Now we're not going to go and say.
NOTE Confidence: 0.862394332885742
00:23:42.650 --> 00:23:56.570
Usually, what would happen is reporting services would ask us to then go and provide the credentials because I've prepped this course that has these credentials cash so this report. Should work right off the bat, so going to unload it and in a matter of seconds.
NOTE Confidence: 0.90275627374649
00:23:58.450 --> 00:24:18.460
We should have a fully function report so if you are needing to test paginated reports within power. BI reports we been able to do this. This is a stock standard report designed in report builder that I was just able to deploy the back end database is a SQL database. So there are issues with the support today or there is a limited number of data source.
NOTE Confidence: 0.845666408538818
00:24:19.250 --> 00:24:39.260
Right now, OK but SQL server is certainly one of them. Unfortunately can't point them at our existing model that is something that is coming. We should possibly customer might speak to some of that later customer. The only going to be speaking about enterprise features just after this so he he's probably the right guard to speak about that OK.
NOTE Confidence: 0.876557886600494
00:24:40.050 --> 00:25:00.060
The important thing is, we've now gone and accessed. This this capacity. We have this ability to test we can show our users. But we also have the ability to shut it down. You know that that I think is the killer feature of premium or using the askews over any other premium skews so how can we do that?
NOTE Confidence: 0.881424069404602
00:25:00.850 --> 00:25:20.860
But it's really only one way to do that, and that's to come back into the SQL back into the zoo portal. Now we can do one of 2 things either. We can scale our our resource down so I can click on the pricing tier and it's going to give me a list of the levels so I could probably go to something like.
NOTE Confidence: 0.876554548740387
00:25:21.920 --> 00:25:41.930
And a 3 on a 2 now that's not going to work because of my reporting services instance. But if you were just using reports you would be able to do that, or you can scale it down to another option. Now we're going to go and pull their option for their report before I do that? What I'm actually going to do just quickly show you so I have this existing report. I have premium capacity.
NOTE Confidence: 0.877534091472626
00:25:42.720 --> 00:26:02.730
I have told you that, if a if a workspace is backed by premium capacity that anybody should be able to access it. I'm just going to show you how that's not going to work for us. So I have here. I have a free user so it's a user on my tenant that has not been assigned a power. BI premium user you can see under the workspaces, he doesn't have access to.
NOTE Confidence: 0.800059795379639
00:26:03.520 --> 00:26:18.240
Workspace now and I had this been up been back by genuine premium capacity my user would have been able to access that report anybody got any questions on this story. I sort of just marrying along you good.
NOTE Confidence: 0.863078236579895
00:26:19.400 --> 00:26:39.410
OK, OK, so, so, so we can see how free users cannot access this capacity, but we've seen how we can spin it up and we can test premium only features using this sort of approach so reading. I didn't go back into the power BI portal. Essentially we can pause it. It's going to ask you are you sure yes, I'm happy.
NOTE Confidence: 0.772606730461121
00:26:40.200 --> 00:26:44.400
Because I don't have P one money.
NOTE Confidence: 0.832309007644653
00:26:45.800 --> 00:27:05.810
I'm from Africa. I don't have alot of money at all OK, so essentially we've got our our instance opposed if we return back back into our prime. Our instance, you can already see, there, it's told me that my previous has has expired. OK, that was just a session token within reporting services itself, but you can see them essentially.
NOTE Confidence: 0.864166736602783
00:27:06.600 --> 00:27:26.610
OK so this is this is the workspace that is back by it. But if I clicked on the report itself. You'll see that I'm going to get a warning that that's going to tell me that that it's not possible for me to access any of these reports anymore. Alright so not not particularly.
NOTE Confidence: 0.869726538658142
00:27:27.480 --> 00:27:47.490
I think anybody here can do that there's a couple of things you are going to need. Obviously you need to be within your own tenant. You would need access to premium capacity. I mean to Azure, which might be something that some of us don't have access to but All in all, I found this process to be very simple. This has been documented a couple of times Chris Finland choose one.
NOTE Confidence: 0.851416230201721
00:27:48.280 --> 00:27:58.290
For the reporting services feature has a document and how you can do this as well. I think Chris has also Chris if you published anything or is it just the tweet.
NOTE Confidence: 0.833750307559967
00:27:59.800 --> 00:28:01.160
The trees in your last session.
NOTE Confidence: 0.789061605930328
00:28:02.890 --> 00:28:18.920
Nothing really OK alright OK, so it might just be Chris is crisp and then not not not OK. So we've kind of sort of tested those features with spun up that report now how might this be useful.
NOTE Confidence: 0.800172984600067
00:28:19.850 --> 00:28:31.480
Right so any questions on what you've seen I mean, everybody here has used the power be. I portal before so you're all good guys know what you want.
NOTE Confidence: 0.896142780780792
00:28:32.420 --> 00:28:52.430
Again, so I think the prime case for this use case is testing so How do I as a business user going demonstrate to perhaps my manager my finance Department? Whoever makes these decisions that these features will solve the problems that we've been having so if you for example, if you gotta slow model you can use the A for instance.
NOTE Confidence: 0.845989465713501
00:28:53.220 --> 00:29:13.230
To to that sort of P one instance could remove some of these bottlenecks. Now the P. One is not and not this silver bullet for performance. But it could get around certain issues and especially it has some sort of sort of sizing issues and larger models and.
NOTE Confidence: 0.876993417739868
00:29:14.020 --> 00:29:34.030
The other big thing the second one is infrequent use and this is why I'm kind of interested in it. I have AI have a client, who who has to do occasional bowling. So he needs to generate an invoice and how he's done that at the moment is he's created a power BI report. I'm sure a couple users have done this before.
NOTE Confidence: 0.847130596637726
00:29:34.820 --> 00:29:54.830
And the power BI report for this invoice and we know power BI. It doesn't really do that particular well. You know the minute. There's more than more than one line items to the number of rows in the table. It's sort of scrolls down So what he does is he takes a screenshot and copies and pastes and he sort of got this really bizarre processor.
NOTE Confidence: 0.844513833522797
00:29:55.620 --> 00:30:15.630
Versus anybody who's been using reporting services or lost 3020 years, OK knows how to do this OK now, what he could do is he could use this capacity. He can split it up. He's only going to do invoicing once a month spends up the spins up the.
NOTE Confidence: 0.853211283683777
00:30:15.650 --> 00:30:35.660
For instance, is does his building shuts it down OK, so from a cost perspective, that's ideal. This particular client could never afford to go to P. One instance alright so certainly that me for him is a solution. That's kind of what I've what I've done for him, so that's working really well.
NOTE Confidence: 0.881440997123718
00:30:36.450 --> 00:30:56.460
And then the other instance, I think might work is scale, OK, if I have a business that for some reason has a lot of report usage at certain times of the month, OK, so maybe I'm on AP. One instance or on a low one. And I have a month in that is particularly harsh now currently the premium skews don't allow.
NOTE Confidence: 0.87492048740387
00:30:57.250 --> 00:31:17.260
If one day of the month and AP one instance for the rest of the month. You might consider this scale option to help you and your business to essentially deal with that pique pique period. Now the the downfall again is going to be that my users are still going to require pro license.
NOTE Confidence: 0.919413149356842
00:31:18.050 --> 00:31:28.770
OK, so unless you have a small number of users that are doing a lot of work at the end of the month. I'm not sure that this is your use case. I mean anybody here think that they might have a use case.
NOTE Confidence: 0.819464564323425
00:31:30.120 --> 00:31:35.340
Yes, tell us about that is exactly that scenario.
NOTE Confidence: 0.860049307346344
00:31:40.810 --> 00:32:00.820
Yes, that that period running OK, so yeah, so essentially our our scale will work. I think I haven't seen that done in production. There was a little bit of concern initially when the initial premium capacities came out in the embedded capacity Microsoft were were sending Adam.
NOTE Confidence: 0.872563362121582
00:32:01.610 --> 00:32:21.620
You couldn't use embedded to circumvent premium licensing again. Now I'm not like a Microsoft licensing person. So you need to speak. It makes a licensing but Microsoft has intimated that it is perfectly acceptable to now use embedding as their licensing scenario, so we are now.
NOTE Confidence: 0.884600281715393
00:32:22.410 --> 00:32:26.600
Well, I think by doing this anymore, which I think we were 2 or 3 years ago.
NOTE Confidence: 0.347214728593826
00:32:28.000 --> 00:32:29.160
Yep.
NOTE Confidence: 0.78148740530014
00:32:30.120 --> 00:32:36.360
Alright so I'm so you guys have been a chatty bunch any questions on that yes.
NOTE Confidence: 0.896133959293365
00:32:41.290 --> 00:33:01.300
Is there a minimum hit in terms of? Time duration so I've found that it roughly takes about 10 minutes OK. So when I spend it down the spindown happens instantly spin up and the capacity changes taking about 10 minutes. I don't know what that would look like on a very large instance that actually had a lot of jobs. I don't know what that Microsoft's minimum.
NOTE Confidence: 0.822058081626892
00:33:02.090 --> 00:33:11.000
But in my experience it, you know, so certainly for that. Dev test so the scenario hasn't been more than 10 minutes. Yeah, it was not the question.
NOTE Confidence: 0.876513183116913
00:33:16.840 --> 00:33:36.850
Yes, OK, so the question is, is would we be able to Automate. This yes, we would so really using runbooks or sort of sort of Web hooks or whatever it is, you would be able to use the Azure automation. API's to do all of this so for example, when we when we said we might not want to turn the capacity.
NOTE Confidence: 0.877383530139923
00:33:37.640 --> 00:33:57.650
One possible scenario is to actually have a webhook where users could who wants to access reporting. You could hit that Webhook First, it would essentially spin up their capacity for that occasional user so users would have the way to spin up that instance for that sort of off peak demand without having.
NOTE Confidence: 0.842564284801483
00:33:58.440 --> 00:34:05.470
Pass the IT Department to spin up that instance, yeah, so we could definitely get that sort of automation that happening.
NOTE Confidence: 0.853825628757477
00:34:13.710 --> 00:34:33.720
Yes, it has been nice in my case so the only the the the version of really tested is going from an A 4 OK, which I need for reporting services. When I scale that down 2 and a one. I essentially the reporting services instance became unacceptable. It will throw your message very similar to what we saw.
NOTE Confidence: 0.849831283092499
00:34:33.740 --> 00:34:41.560
When we try to access the capacity when it's off. It says it just doesn't have the resources to you know the resources to back their capacity anymore, so that.
NOTE Confidence: 0.840325474739075
00:34:43.260 --> 00:34:58.360
It should I mean, I ought to be honest, I haven't tested that case, but at the portal remain fully active while I was doing it. So I don't know if he did 'cause. It's actually so that'll be AII can't really change it, but yeah, I don't see any problems with that.
NOTE Confidence: 0.881799399852753
00:34:59.300 --> 00:35:00.230
Any other questions.
NOTE Confidence: 0.797660231590271
00:35:01.830 --> 00:35:17.030
Alright so now I think it's it's not lunch. Yet is it. Not quite OK. Now I'm well. Thank you guys don't forget to fill in your evaluation forms have enjoyed it.