Power BI

A finance user case The Star Schema methodology is the application of dimensional modelling techniques to a relational database. This includes not only simple star shaped models, but a wide range of techniques such as snowflaking or factless fact tables. These principles should (almost always) be adopted in Power BI (a relational-like database). This article discusses one of the exceptions; dealing with subtotals.

Let’s face it: sometimes canvas apps end up too complex and users get easily little bit lost with where to find which functionality or even what features are available. To be easily able to p…

To enhance the look and feel of the Canvas App, we can use a fluent UI framework by using the Creator Kit. The Creator Kit helps create Power Apps experiences on the web and mobile platforms with convenient components appearing in modern software. Prerequisites - The Power Apps code components for the Canvas Apps feature

usiness users often need to know how fresh the data is that they see on a Power BI report. This requirement can be interpreted to mean either “when was the last date & time that the sour…

Prevent the "The resultset of a query to external data source has exceeded the maximum allowed size" error in Power BI by building aggregations

Why the 'supply chain of data' has reached it's terminal endpoint, a history of how we got here, and a glimpse at what comes next.

Companies need to rethink how they’re investing in data, analytics, and AI — and whether these investments are creating real business value.

From time to time I got asked how customers can export Paginated (or Power BI) Reports automatically to store them e.g. in OneDrive or any other location. One way is obviously to do it manually, bu…

Referencing a different query in Power Query will usually return the final step. But what if you want to fetch another step within that query?

Power Platform Connections is a new show hosted by David Warner and Hugo Bernier from the Power Platform Community Team....

""

Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.

Learn what is an accordion gallery and how to make one in Power Apps using either a single gallery or nested galleries!

Learn how to perform batch updates in Power Apps! Should you use ForAll + Patch or just the Patch function? Which one is more performant?

Custom pages bring model-driven apps and canvas apps together! However, you cannot add multiple screens out of the box. Learn how to!

Case I want to send streaming data to Power BI for reporting purposes. What should I take into account when choosing the right architecture...

In this post we look at how to use Smart Buttons (flic) with Power Automate and Power BI to create and control types of event-driven reporting solutions.

Two demos: Turn that ‘Power Apps’ app into a Mobile app! and List Formatting Magic – Query string options and look up field handling. Delivered 4 Independent Publisher Connectors, 2 Teams, 7 Script, and 2 Power Apps samples.

If the audience for your Power BI report is larger than 12 people, then statistically 1 of your audience suffers from Colour Vision Deficiency. In this post we will talk through how we experimented with colour to develop an accessible colour palette and why colour and contrast is important when it comes to data visualisation.

The Financial Times is a source of great data-driven stories told through data visualization. The Financial Times vocabulary poster is a simple yet comprehensive tool … Read More

This tutorial shows you how to use PowerShell to import data from a CSV file, then use a foreach loop to take action on each item.

The environment concept (in our opinion) is one of the most important concepts in M, while it is one of the least obvious ones. This series of posts is written in collaboration with Imke Feldmann from thebiccountant.com Part 1 – Introduction Part 2 – Environments in single nested records and let-expressions Part 3 – Global and local environments and […]

We believe DataOps is the function within an organization that controls the data journey from source to value. DataOps is critical to any growing business working with any type of data.

When you compare DataOps vs. DevOps, you’ll find there are similarities. But there is a fundamental difference between them as well.

DataOps takes a page from the Agile approach to design, implement and maintain a distributed data architecture and derive trusted business outcomes.