Power BI

In the previous article and video, I explained the important factors in having a successful data analytics team. One of those aspects is the team, the people, and their roles. In this article and video, […]

This may come as a shock to you (unless you work in retail), but “weekend” does not equate to “Saturday and Sunday” everywhere.    Here is a nice overview, courtesy of Wikipedia: https://en.wikipedia.org/wiki/Workweek_and_weekend As you can […]

I was doing some work recently for a customer and they had data stored in different Lakehouse’s which was in a different App Workspace. I was pleasantly surprised that this can be quite easy to […]

I really enjoyed recently working through the latest Power BI Challenge from Enterprise DNA. This was not an easy scenario that we were dealing with. We had some HR consultation data and the required analysis […]

Want to create well formatted reports that contain several pages of data with a simple drag and drop experience? It’s now possible with the new paginated authoring experience in the Power BI service. With this […]

Recently, I have come across the interesting scenario below, while working on a customer issue. Issue: I have a report with row level security (RLS) implementation; when a user logs in, they have visual filter […]

In this blog, I would like to address one of the issues that I came across recently with the RANKX function where the Ranking Score is different, even though the Sales Amount is exactly same […]

In practical business, data iteration is widely used, such as present value or depreciation. However, as we all know, DAX is a functional language based on column engine. Each row of data is calculated based on […]

Issue: Recently, I came across an issue where a customer wanted to automate the dataflow refresh in Power BI, whenever there is an update in an Excel file stored in Teams/SharePoint. As of today, Power […]