Power BI

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 →

A tool for customizing and dynamically generating a tabular model from an existing tabular model. - m-kovalsky/MiniModelBuilder: A tool for customizing and dynamically generating a tabular model fr...

My post on which languages to learn as a Power BI developer resonated with many people so I thought I'd take a step back and write about how to navigate the various facets of the business intelligence job market. Where language selection is effectively a tactical tool choice, in this entry we'll focus on the

I need better equipment… I tell myself while trying to jog off the extra pounds I gained in 2020. The earphones I am wearing slowly loosen from my ears with each step and I can feel each contour of the blacktop with my worn-out sneakers. I manage to finagle the earphones just right to listen to a new podcast Building the Backend by Travis Lawrence. He is interviewing Chris Bergh from Data Kitchen and a principal author of DataOps. I had heard the term before, DataOps, and read the manifesto, read the DataOps Cookbook, and I had researched how DataOps is the fusion of DevOps, Agile, and Lean Manufacturing. The stories Chris and his colleagues share about clients calling about bad data in reports, ETL pipelines failing in production, and clients who thought new features could be delivered quicker were all experiences I could relate with. I had been a convert for a little over a year and wanted to hear more.