Area step one: Use Line-Peak Safety inside Electricity BI Desktop

Provide: Nine needs material adapted from various workshops by Jose Lena Stevens, Pivotal Resources and JP Van Hulle, Michael Education Foundation.

Examining data having Energy BI has become interesting in my experience. Which have actually ever-increasing data appear way more risk, and therefore far more safety required. In this post, I’ll introduce what line-peak shelter for the Fuel BI was and exactly how can it functions. I am going to also have indicated in more detail how exactly to implement an equivalent inside Energy BI Pc. Later on, we will along with discuss how-to implement it row-peak protection into the Energy BI solution too. To learn about row-top coverage when you look at the SQL Server, please have a look at my earlier in the day post, in which You will find said how exactly to pertain a comparable.

Uploading Investigation into Fuel BI

Step one inside proving one Stamina BI ability will be to weight this new dataset into Electricity BI ecosystem and create the needed graphics. For it article, I’ll make guyspy bezplatná zkuÅ¡ební verze use of the greatest AdventureWorksDW databases, because available with Microsoft. You could install so it databases and have now it attached to their Desktop.

Discover a number of dining tables regarding the AdventureWorksDW database. I have selected a number of dining tables regarding the database, being below.

Finally, carry out a sample writeup on and this you may like to use the newest row-height protection when you look at the Energy BI. For it example, I’m going to lay this new row-peak defense towards the SalesTerritoryGroup line. As you can tell, the fresh SalesTerritoryGroup line is next put into SalesTerritoryRegion. As soon as we designate spots so you can a certain territory classification, only research associated regarding classification could well be apparent when you are other suggestions is invisible regarding the screen.

To help you use row-level defense into the Strength BI, demand Modeling case above, and pick Carry out jobs.

After you click on Would, you should have a listing of tables regarding the research model away from which you are able to get a hold of a filter to utilize new row-height safety.

Replace the “value” from the DAX expression which have an actual value throughout the SalesTerritoryGroup. Let us range from the worth as the “Europe” and you may in a way that this part usually filter studies just for people info for European countries because region group.

Ultimately, why don’t we carry out a role getting a manager who would like to screen sales round the Europe and The united states. We must promote usage of both these territories to the movie director. You should use the second term in order to designate one or more worth to possess a job.

Since we have developed the jobs let us go ahead and find out the implementation inside real. There was an option when you look at the Electricity BI, where we could understand the reports throughout the perspective of one’s jobs that people just composed. This will help you take to if the DAX filter terms is actually being employed as questioned, and if the newest row-height defense from inside the Stamina BI would be then followed correctly.

Let’s try to see how the latest reports browse when we pick a unique character. Come across European countries due to the fact role and go-ahead to come.

You can easily notice that the fresh new report tends to make the fresh visualization, but just for the particular character that’s picked. It’s also possible to notice into the remaining-give better that it’s said since the “Now watching statement once the European countries”. Notice how the nations simply for European countries is actually blocked and range graph now suggests just one range, that is for Europe merely.

Since I will filter with the region class, I shall grow the fresh DimSalesTerritory and pick Incorporate Filter out immediately after which come across new line SalesTerritoryGroup

Clearly today, all of the areas that belong so you’re able to United states to be shown in addition to a single range for similar throughout the range graph.