Power BI

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.

There is no secret about this. If you do any legitimate research about Power BI (reading blogs, books or training from reliable sources), you will quickly learn that a lot of basic functionality re…

Power BI Usage Metrics Report If you build it, they will come.  That movie line doesn’t just fit baseball diamonds, it is often uttered when an