In one of the projects, I was working on, I received feedback saying it is hard to understand how many items they have selected in a slicer, and it is not the first time I came across this. It is a valid point, especially when you have quite a few items in a slicer, you… READ MORE
It’s been a while that I use Microsoft To Do to organise my daily tasks. From work-related tasks to buy groceries. While Microsoft To Do is super easy to use but there are some challenges in using it more efficiently, especially when you have multiple O365 accounts within different organisations. Here are some of the challenges I faced; you… READ MORE
Power BI doesn’t yet have a feature that allows end-users to turn on/off the ability to process calculations for visuals on a report page until they are ready. Most of the time, this is perfectly fine – however, in some instances, it can be handy to disable long-running and heavy calculations from running. At the… READ MORE
SharePoint and Power BI can work very well together. SharePoint can be a data source (lists), a container for data files (Excel. CSV etc in libraries), and as a dashboarding platform (pages). This demo rich session will explore all of these scenarios in great depth. SharePoint data can be finicky to retrieve, and this session… READ MORE
Recently I have been working where I have multiple accounts, and I wanted to test the different access to the accounts when connecting via Excel. Today we will discuss Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services. I could not find any blog posts or videos… READ MORE
I have been playing around with the new awesome (preview) feature in the December Power BI Desktop release where we can use DirectQuery for Power BI datasets and Azure Analysis services (link to blogpost) In my case I combined data from a Power BI dataset, Azure Analysis Services, and a local Excel sheet. The DirectQuery… READ MORE
Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it. This post walks through the basic steps to set up the refresh. Dataflow Series This post is part of a series on dataflows. Create a dataflow Set up dataflow refresh Endorsement… READ MORE
“Learning is a process, a method, an area of mastery, and with effort, focus, and practice, we can get a lot better at gaining expertise.” – Ulrich Boser Analyzing Data with Microsoft Power BI Exam Today I am going to speak to you about Exam DA-100: Analyzing Data with Microsoft Power BI. I will talk… READ MORE
The sort by column feature of Power BI hides some potentially unwanted complexities. This blog post shows how you can avoid having to sort a column by another column while maintaining a custom sort order. The problem Here’s a typical example: you sort month names by month numbers. Let’s say you want to remove filters… READ MORE
With Power BI you can set up a scheduled refresh of any dataset which have an accessible data source. But you must be aware of, how many refreshes are at the same time. With every particular capacity you have only limited parallel refreshing resources. So, you can only refresh one dataset at the same time… READ MORE
