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.

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

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

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…

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 […]

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?

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.

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.

Power BI Desktop sample files for the monthly release. Here you can find the PBIX files used in the monthly release videos. Power BI Theme Files

With the help of newly added tooltips, you can check your formulas directly in the formula bar or in the cell you're editing.

For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL Server users etc. and all of these are tied into the ETL process of a data warehouse. Some are used to connect to source data, other

This post explain one of controls of Craator Kit: Nav Control. Is really nice control to create beautiful navigation menu or tabs for your app.

Build beautiful, usable products faster. Material Design is an adaptable system—backed by open-source code—that helps teams build high quality digital experiences.

As we enter a new year, more gyms are packed, more books are read, but within the first month, about a third of individuals will see a dissolution of their goals. Setting goals and sticking to them isn’t just a challenge for personal pursuits—it holds true for your professional life too.    Organiza...

In the 1st post of this series, learn how to build expandable checklists using nested galleries in Power Apps!

Today, we’re announcing a public preview of the new model driven app experience and providing an update on new controls coming to canvas apps in the spring timeframe. Before driving into the details on what the new model driven app experience brings, I want to provide some context about the enhancements and our plans for…

Welcome to the Power Apps monthly feature update! We will use this blog to share a summary of product, community, and learning updates from throughout the month so you can access it in one easy place. A variety of new and highly anticipated features are now available which we are very excited to share. We…

New options for applying custom styles and colors to sites that make it easier to define and manage themes across site collections.

Welcome to the January 2023 update. This month we are excited to announce the release of PivotTable show details to Excel for the web and the ability to automate your tasks with the Power Automate tab in Excel for Windows and Mac. For Insiders users on Windows and Mac, you can try recording your wor...

In this post, we will walk through how you can use the Web API capabilities of Power Automate to manage the Power Automate Desktop flows.

Want to level up your customer service game? Discover how to automatically detect negative customer emails and take immediate action with Power Automate and Microsoft Teams integrated with AI Builder’s sentiment analysis. Don’t miss out on this powerful solution for top-notch email management.

This is a collaboration of Luise Freese |@LuiseFreese and Robin Rosengrün | @power_r2

Back in August 2022, Microsoft released a feature to have multiple audiences for Power BI Apps, or if you will deploying multiple versions of the same app where you can actively show and hide conte…

Learn about Power BI workspaces, what they are, how they can be managed and used for sharing content with their pros and cons.

So, for 2023 I’ve decided that I want to learn Azure Synapse. I want to be able to make training content on it by the end of the year. I’d like to be able to consult on it in two years. And right now, I am absolutely banging my head against the learning curve. Let’s … Continue reading Why I’m struggling with learning Azure Synapse →