Power BI

This blog walks through how to use Power BI Bookmarks and it's capabilities that allows users to capture a specific state of a report page.

This blog explores the 4 steps that can genuinely help your organization build an actionable analytics strategy roadmap. Read today!

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

fascinating exactly what I was saying with #lowcode and generative models complementing traditional development (not just coding but in this case data…

Power BI Desktop sample files for the monthly release. Here you can find the PBIX files used in the monthly release videos. - powerbi-desktop-samples/README.md at main · microsoft/powerbi-desktop-s...

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…

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

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

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…

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...

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.

Here is how to create a jitter chart in Power BI with averages by categories and using only Power BI and DAX capabilities.

Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. This whitepaper is a draft.

Helpful intro for Windowing Functions

Welcome to the January 2023 updates on Power BI Datamarts. This month, we’ve added a variety of new features based on your votes on ideas.powerbi.com. There’s more to explore, as well as a sneak peek of what’s coming soon, so please read on!

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.

Allow end users to pass any value they want to a dynamic M parameter in a Power BI DirectQuery dataset

Power BI ❤️ Dynamics 365 CE Sales! (beta) Template Sales Reports for Power BI and Dataverse. - GitHub - mscottsewell/Power-BI-D365-Sales: Power BI ❤️ Dynamics 365 CE Sales! (beta) Template Sales Re...

No Premium - no problem! What do you do if client asks for performance optimization, and there are no premium features available? You improvize and win!

This blog post shows how to setup and configure Power BI Premium/Premium Per User datasets to be backed up.