Monthly Archives: May 2023

PL-300 – Section 37: Part 4 Section 6 – Create and Manage Workspaces

274. Create and Configure a Workspace Hello. Now, up till now we’ve been using the private workspace called My Workspace. You can share items from it, but it’s not really designed to have a big solution being there. However, workspaces, which can hold data sources, datasets, reports, and dashboards can be more than just My… Read More »

PL-300 – Section 36: Part 4 Section 5 – Manage Datasets Part 2

271. Configure a Dataset Scheduled Refresh In the previous video, we installed a gateway connection, which will allow Power BI Service to connect to my computer. In this video, we’ll have a look at how we can refresh the data automatically. Now, your data source cannot be refreshed because your credentials are invalid. Okay, let’s… Read More »

PL-300 – Section 36: Part 4 Section 5 – Manage Datasets

267. Analyze in Excel Hello. And in this section, we’re going to be looking at managing databases. So again, we will have a video for each of the DA-100 exam requirements. And we’re going to start off with Analyse in Excel. So, you’ve got your datasets and also reports, open the Power of BI Service… Read More »

PL-300 – Section 35: Part 4 Section 4 – Dashboards Part 2

264. Add a Dashboard Theme In this video, we’re going to have a look at Dashboard Themes. And we’ve already had a look at themes in Power BI. When we were going into the themes, we were able to say, well actually, I want my page to be of a particular theme. And that alters… Read More »

PL-300 – Section 35: Part 4 Section 4 – Dashboards

258. Differences Between Dashboards and Reports Hello. In this section, we’re going to have a look at Dashboards in the Power BI Service. Now, dashboards and reports sound similar. So, what we’re going to do first of all, in this video is look at the differences between dashboards and reports. Then we’re going to look… Read More »

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 »

img