DAX Datesytd Year End Date not working in power bi service

I thought I'll document and share a DAX scenario from Ian Y. who contact me on LinkedIn asking for advice. The problem was that DAX Datesytd function was not working as expected with Year End Date argument which is used to change fiscal year beginning/end in the calendar. The argument that Ian provided was "1/10" for October 1st and this worked in Power BI Desktop but didn't work in Power...
Read More

Power BI table naming conventions standards

We offer Power BI consulting services using our Power BI Flexi Team and in this article we will describe our table naming conventions standards that our team members should adhere to. If you a website visitor (not part of our team) please note that we will use quite a specific way to name tables and feel free to adjust it to your liking. When we work with Power BI solutions...
Read More

Power BI best practices naming conventions standards

We offer Power BI consulting services using our Power BI Flexi Team and one of the benefits of the service is that we have Power BI best practices that we adhere on every project and that includes naming conventions standards. The best practices and naming conventions standards that I will describe here is what we use in all our projects, and we expect all our team members to adhere to,...
Read More

Katie and Emil Power BI Flexi Team – Our consulting service

In May 2021 we officially offer a Power BI consulting global service called Flexi Team. Before 2018 I was contracting, relocating for contracts and expected a baby and it was time where I finally decided that with my wealth of experience in BI with Microsoft BI tools, it's time to make a strategic decision to grow not as a contractor but as a Power BI consulting business. My main motivators...
Read More

Power BI could not load file or assembly microsoft.web.webview2.core

I got this error today (24th of May 2021) while working on a project for one of my clients, and trying to sign in to Dynamics 365 using organizational account. Something went wrong! The solution for me was to download the latest Power BI update, I think I was already using May 2021 but it seems there was an update to an update. For some reason I only had Repair...
Read More

How to become a Microsoft MVP

So like me, you are interested in becoming and Microsoft MVP and wonder how exactly to do that? The main criteria to become a Microsoft MVP is to contribute to the community, and over 10 years ago that's exactly what I started doing by creating SQL Server BI Stack (T-SQL, SSIS, SSRS, SSAS) blog, which I later on expanded into an e-learning website, which at some point was being visited...
Read More

Why social skills are important for IT job success

I regularly check Itjobswatch website for statistics related to IT jobs and Microsoft Power BI (Consulting service we offer) and recently there was a major change in top 5 IT skills where we suddenly got Social Skills as #3 most in demand skills. Let's start with a definition of social skills. ITJobswatch puts in brackets interpersonal, communication which essentially is a soft skill related to how we communicate at work...
Read More

Azure permissions to start and stop virtual machines

Part of our Power BI Consulting services that we offer, we have clients where development is done on our side, and our standards dictate that to use an Azure Virtual Machine in the region the client resides, so all the data is kept in a virtual machine in the cloud. Here's I'll be sharing steps that I took to set up the permission to allow one of our team members...
Read More

Power BI Consultant day and hourly rate

Have you wondered how much a Power BI consultant is paid on a day rate or hourly rate? I discussed rates and salary in my free ebook "A Career with Microsoft Power BI" and in this post I would like to expand on it and also narrow it down to a single role which is a Power BI Consultant. Let's start with a definition of a consultant, in this post...
Read More

I recovered from schizophrenia to a point where I hope to live a normal life

It's no secret that I have been diagnosed with a mental health disorder called paranoid schizophrenia in November 2018 (at age of 35) when I experienced my first episode and was taken to a mental health hospital for several weeks. Unfortunately I didn't "believe" in medication / drugs treatment, so I didn't take it and experienced severe episode in May 2019 where I lost memory for 3 weeks, was in...
Read More