Power BI

A conclusion and extra resources of the Power BI adoption roadmap series of articles.

Office Scripts are an online version of VBA. Built to run in Excel online, it is similar to...

Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this article, we introduce this optimi

We are thrilled to announce that based on your feedback, we have decided to bring back the feature that allowed app consumers to save copies of reports to their My Workspace. Further, app authors can now by default collapse the app navigation pane for their app consumer.

All Power Apps forms should perform data validation, have error handling, protect against lost of unsaved data and restrict input values.

Welcome to Azure Data Factory’s October monthly update! Here we’ll share the latest updates on what’s new in Azure Data Factory. You can also find all our updates on our What's New in ADF page.    We’ll also be hosting our monthly livestream next week on November 10th at 10:30am PST/ 1:30pm EST! Joi...

Learn to use these 3 Power Automate error-handling patterns: 1. Try, Catch Finally, 2. Terminate Actions, 3. Get the Flow Run URL.

In this post I will show how to call Dataverse Custom APIs from a Canvas App with the use of a generic Power Automate Flow and the new ParseJSON functionality.

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…