Power BI

We’re glad to announce that formula repair is now available for you in preview. We know when writing formulas, errors are unavoidable, and troubleshooting could be time-consuming and cumbersome even for tiny errors like a missing parenthesis. With formula repair, now you may skip some of the troubleshooting effort as whenever you have a formula … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/formula-repair-now-in-preview/" class="more-link">Continue reading<span class="screen-reader-text"> “Formula repair now in preview”</span></a></p>

A few weeks ago I wrote a post showing how you can use the new EvaluateAndLog DAX function to diagnose performance problems relating to the use of the Switch function. Did you know that calculation…

In October 2022, two new DAX functions appeared in the Power BI service: TOCSV and TOJSON. In this blog post, I'm showing a few use cases.

Did you know there are a lot of keyboard shortcuts for the advanced editor in Power Query that can save you time?

Sometimes, when you’re analysing data, you need to be able to change variables and see what the impact is: for example you might want to see what your profit margin looks like if tax rates ar…

STOP defaulting to exporting your Power BI data to Excel! Adam shows you options you can use within Power BI to still work with your data in Excel if that’s what you are comfortable with.

We love Community! Thus, we are announcing a new app dedicated to the Community Jam. All things Power BI written by the community!

Explore 6 actionable steps that will help enhance and expand the analytics capabilities of your team with this insightful blog.

Learn what is new in the Visual Studio Code October 2022 Release (1.73)

A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this article, we explain the reasons why

What kinds of things can we do to ensure adoption once the reports are live? One of the easiest ways is to host a regular “data café” surrounding the solution. In this article we examine why this is valuable.

Tips, tricks and best practices to know when developing a Power BI solution. Each explained with links to study more

Most struggle with getting Q&A to be effective in Power BI. Usually this comes down to either model naming or synonyms. Patrick shows you how you can update these and also a nice feature to let you share them with others.

ABSTRACT 📝 Power BI is incredibly powerful at distributing and sharing data insights, through visualizations, across an entire organization. The democratization of Business Intelligence that Power BI brought with it is unparalleled. But Power BI on its own has its limitations and will often fall

Blogging about Power BI, Power Platform and other things I find interesting.

Occasionally you need to change to point to a different tenancy which means changing a connector to switch Dataverse tenancy.

Get an overview of what Power BI Datamarts are, why they’re important, and some real-world use cases in this engaging blog.

You’ve probably heard the term lakehouse with various services like Azure Synapse Analytics. But what actually is a lakehouse? And why is it different from a data warehouse?

Video by: Reid Havens Join Daniel Marsh-Patrick and I as we show you how to use the Deneb (Bespoke Visual Creator) to create two ways to display a countdown timer ! This is a follow-up video to a previous concept I created using the Play Axis slicer to rotate filter selections on

Bravo is a free tool created by SQLBI that helps you create a Power BI model with a simple user interface: Analyze Model, Format DAX, Manage Dates, and Expo

We get a lot of questions about Power BI dataflows and when to use them. Patrick explores a use case that screams for using dataflows! Are you taking this approach?

Learn how to move data from Google Analytics into the Snowflake Data Cloud with this step-by-step blog. Read today!

Learn about what is Power BI Service or website and why do you need that, what features and components comes with it.

More and more I am working with Azure Synapse analytics as the location of data for Power BI, and there are 4 different ways that you can incorporate Power BI. Incorporating Power BI inside of Syna…

With practice, as well as powerful changes to your cognition, you can improve your ability to analyze information and ultimately make the best decisions for your life. Here is our Quick Guide to improving your critical thinking skills.

Power Query Custom Data Connector for Power BI REST APIs (Commercial) - powerquery-connector-pbi-rest-api-commercial/README.md at main · kerski/powerquery-connector-pbi-rest-api-commercial

DataOps Principle #16 - Monitor Quality and Performance

With Power BI we're very restricted with how we can use text in our visuals. This video shows how to create and add amazing dynamic details to your report to better communicate the data to users. Referenced Documentation: Window in Vegalite - https://vega.github.io/vega-lite/docs/window.html

On the Microsoft Power BI Ideas Forum (https://ideas.powerbi.com/ideas/), there is a long-running re