PL-300 – Section 38: Part 4 Section 7 – Other Power BI Service Topics

281. Create a PivotTable from a Power BI Dataset in Excel Now, suppose you didn’t actually want to export the data, you just wanted to do an analysis in Excel, namely a pivot chart. So that’s equivalent of a matrix in Power BI. Well, you can do this in Excel fairly easily. But you might… Read More »

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

278. Promote or Certify Power BI Report or App Now, that we’ve created an app, how can we say how good an app this is? You’ll remember that a few videos ago, we were able to promote or certify or endorse datasets. Well, as of around October 2020, Power BI now allows you to endorse… Read More »

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 »