PL-300 – Section 34: Part 4 Section 3 – Row Level Security

255. Adding Role-Based Row Level Security In the previous video, we created this report, and we shared it with Susan and Jane. But Jane should only be able to see bikes and Susan should only be able to see accessories and clothing. So, we need to implement some security and we implement the security on… Read More »

PL-300 – Section 33: Part 4 Section 2 – Power BI Pro and Adding Users

251. Signing up for Power BI Pro Hello, and welcome to part four, section two of this Power BI course. And in this section, we’ll be looking at Power BI Pro. Power BI Pro is for sharing, and so we need some new users. So, what I’ve done is, I have signed for completely new… Read More »

PL-300 – Section 32: Part 4 Section 1 – An Introduction to the Power BI Service Part 3

248. Get Data – Other People’s Data In the previous video, we had a look at datasets and reports, but what if you wanted to bring in data yourself? So, instead of having a dataset that, perhaps, we brought in from Power BI Desktop, how can you bring one in? And we have at this… Read More »

PL-300 – Section 32: Part 4 Section 1 – An Introduction to the Power BI Service Part 2

246. Power BI Terminology In this video, we’re going to have a look at some of the key Power BI service terminology. And we’re going to start off with data sources. Now, data sources are where your data has come from. So, it could be that it’s come from an Excel spreadsheet, a CSV, comma… Read More »

PL-300 – Section 31: Part 3 Level 9 – Other Modeling and DAX Topics for the Exam Part 2

239. Resolve Many-To-Many Relationships – Different Types of Granularity In this video, we’re going to have a look at another reason why you might have a many-to-many relationship. And that is detailed data on both sides of the relationship. So, if we go into our data, and have a look at the other two spreadsheets,… Read More »

PL-300 – Section 32: Part 4 Section 1 – An Introduction to the Power BI Service

243. Welcome to Part 4: The Power BI Service Hello, and welcome to part four of this course, and here we’ll finish off the PL-300 requirements, so let’s see what we’ve got. We will be creating dashboards, we’ll be managing files and datasets, managing workspaces, and doing a little bit on getting data from different… Read More »

PL-300 – Section 31: Part 3 Level 9 – Other Modeling and DAX Topics for the Exam

235. Create Calculated Tables Hello, and welcome to this last level of part three, and in this level, we’re going to have a look at all of the items from the DA-100 certification, that haven’t fitted neatly into the other levels. Now, in, a previous, level in part two, we had a look at the… Read More »

PL-300 – Section 30: Part 3 Level 8 – Time Intelligence Functions

223. Date and Time Functions Hello. In this section, what we’ll be doing is looking at time intelligence functions. These are functions that are not usually included in Excel. But before doing that, I just want to have a look at all of the date and time functions, excluding the time intelligence functions that we’ll… Read More »

PL-300 – Section 29: Part 3 Level 7 – Filter and Value Functions Part 3

216. FILTER Now, suppose I didn’t want the entirety of the table which all does, all changes the context to the zoom out and getting all of the rows. What if I wanted to go from my starting point which is the context and go even further down? Let’s take an example. Let’s get back… Read More »

PL-300 – Section 29: Part 3 Level 7 – Filter and Value Functions Part 2

213. RELATEDTABLE and COUNTROWS So, that’s all very well going from the many to the one, but what if I wanted to go from the one to the many? For example, I have these categories. What if I want to know for each category what the total number of sales or the total standard cost… Read More »