Power BI

In this blog I show you how to get the Xth Weekday of the Month in a canvas Power App. I expand to show you how to get all of the weekdays.

We can make positive values the color green and negative values the color red using conditional formatting in a Power Apps gallery.

A step by step approach to write an optimized median measure in Dax

Colleagues: if I have sent you to this post, it is because I respect you and want to make sure we use common language communicating about our Power BI project. This post is written with an audience…

In this post, we will learn about 'each' & 'Underscore _' in Power Query. We will also know how we can use them with Table & List!

Why is DAX so hard to learn? It is an evergreen topic. DAX is difficult to learn because of its inherent complexity. DAX is presented as difficult to learn in ways that do not align with this complexity. The topic is evergreen because of demography among DAXists. This difficulty has spawned a movement, for lack of a better term, rebelling against CALCULATE and purporting to improve the experience of writing DAX by writing it worse. In this post, I will explore these topics and share some opinions on the same.

how you can remove unwanted spaces from your data in Power Query. We will be also know about building custom functions & also working with it.

While participating in the 25 days of DAX Fridays! – Second edition challenge by Curbal, I was searching for a good way of finding the MAX value from multiple columns in a table.During my search I found a nice technique which requires very little DAX code but is perhaps not the most intuitive solution. In ... Read more

If your Power BI dataset is too large you may get the "Unable to save the changes" error message when you refresh it.

Dataflows can be a very useful and powerful data transformation tool to centralize & govern transformation logic. In this article are some points to consider when making & deploying Power BI Dataflows in your organization.

A checklist to ensure your Power BI App is structured, secure, well-designed and helps users find what they need to use your Power BI reports.

Learn about two techniques for creating a single value input Slicer in Power BI Desktop! The first method will apply a technique outlined in a SQLBI article (link below) that uses Tabular Editor to allow native columns (fields) to be modified to allow single value slicer types to b

Have you ever wondered how to convert Power BI metadata (i.e. from Tabular Editor) to a .pbix? Recently, I needed to do this. Thankfully, pbi-tools (and Mathias Thierbach) came to the rescue! This is not supported by Microsoft, but it’s interesting to know that this approach does exist.

This blog post details how to get the data lineage from a Power BI dataset, to table, to data source to Power Query to easily view!

A colleague of mine came to me with an interesting use case, “ Switch between a summarized value or selected value with multiple legends”. For example, I have five countries…

A while back Adam shared how you can share a personal bookmark with others. There is now a better way to share personal bookmarks in Power BI if your report is in a workspace. Learn how! Share Power BI reports and dashboards with coworkers and others https://learn.microsoft.com/power-bi/collaborate-share/service-share-dashboards Alternative to sharing a Power BI Personal Bookmark […]

After some experiments I have just published new version of the Seasonality page of my experimental showcase Krakow Bicycle Counters report. Also I’ve shared the … Read More

ABSTRACT 📝 There's never a dull moment in the life of a Power BI Administrator . In order to protect our time and sanity, it's important to automate as many of our usual tasks and processes as possible. Additionally, since the top priority of the Power BI development team is the end

Slow data refresh process? Check this article to learn about the most common bottlenecks in the data refresh workflow!

ABSTRACT 📝 Microsoft Power BI tool consistently provides new features and capabilities to transform the raw data into meaningful insights . Effective UI/UX solutions can be driven by various different functionalities such as, but not limited to: built-in visual-related formatting opti

It is long overdue, but time for a new updated version for the Power BI Model Documenter external tool! The latest release lasts from the first week of 2022 and since then close to 6000 people have…

In the Power BI March 2022 feature update, a new feature for the Date Slicer was introduced whereby the Date Slicer had a calendar icon right next to the dates by default. While this feature is des…

Learn what to consider when designing and developing a robust BI platform.

Establish a Center of Excellence (COE) to drive strong and successful adoption of Power BI.

Establish a community of practice to help users drive strong and successful adoption of Power BI.

A few months ago we published one of our blogs to parse the JSON string using regular expression. As per the blog, to parse the JSON string into JSON object we have to format the JSON string into regular expression format as shown below: "{""id"":""(?id[^""]*)"",""name"":""(?name[

We can read about the architecture and the life cycle of the Power Apps component here. Check the screencast – PowerApps Component Life Cycle Let us see it in action using a sample project. Launchi…

Guidance on how to create Power BI data models for Dataverse, PowerApps, and Dynamics 365.

New MSFT Guidance: Power BI for Dataverse. - I've documented the keys to performance and usability with #PowerBI reporting over Dynamics 365 CE or Model-Driven... 20 comments on LinkedIn