Learn to use the Query option of the OData.Feed function in Power Query and Power BI

We’re excited to start the year by announcing updates to the Power BI in Microsoft Teams experiences. Today we’re announcing three new capabilities that are starting to roll out, and a hint about things to look forward to in the coming weeks.

New year, new features! We are excited to announce the general availability of the Viva Goals Power BI integration and three new Metrics features specifically answering common customer asks. A new, optional column for milestones, scorecard time zones, and a handy auto collapse / auto expand feature.

Thank you Power BI Community and look back of 2022 feature releases, and when the upcoming release will be available.

Learn to solve the dynamic data sources error with OData.Feed in Power BI by relying on query folding

DAX window functions can result in simpler, more efficient SQL when using Power BI DirectQuery mode and a greater likelihood that aggregations are used

Every year, on the anniversary of the first-ever post on this blog, I write a post reflecting on what has happened to me professionally in the past year or discussing a non-technical (but still work-related) subject. Two years ago I wrote a post about people who ask the question “Why don’t you add this one

Why using a column from a large fact table as a dimension could result in errors in Power BI DirectQuery mode

Use new Excel functionality to return small multiples of sparklines

Thoughts on why Power BI is a semantic layer or metrics layer

How does the Optimize ribbon, with Pause visuals, Refresh visuals, Optimization presets, and Performance analyzer, as well as Edit relationships in the properties pane work to streamline your authoring experience? Here are some scenarios they can help you with!

This session will teach campers how to use the new SDK support to initiate an embedded Quick Create session which allows the user to dynamically build a new dataset and report on the fly.

Welcome to the December 2022 update! This month, we’ve added a variety of new DAX functions, updated slicer type formatting, and brought Metrics to the Windows app. There is more to explore, so please read on!

I love Excel as an alternative to Power BI reports, especially now that Excel Online allows you to interact with browser-based Excel reports that use Power BI datasets or the Excel Data Model (aka Power Pivot) as a source. After all, why try to recreate a PivotTable in a Power BI report when you can

Power BI Premium Platform updates to unify back-end and front-end v-cores delivers a simplified capacity management experience for capacity administrators.

Cancel an in-progress dataset refresh in Power BI

You can now create a subscription to a view of a Power BI report uniquely relevant to you. By selecting Include my changes, any filters and slicers you have selected will be captured in your subscription.

Announcing new Power BI Metrics features hierarchies and linked metrics.

There was a time when a new release of SQL Server – and therefore a new release of SQL Server Analysis Services – was the most exciting thing in the world for me. New functionality! New things to blog about! Not so now that my focus, and Microsoft’s, is on Power BI and we get

The Power BI Matrix visual is similar to an Excel Pivot table, however there are quite a few limitations in the Matrix. In the Power BI Matrix below I have put the product categories on Rows, Calendar Year on Columns and the measure [Total Sales] on Values. At this point, [...]Read More »

One of the most popular topics I’ve ever written about here is the dataset refresh errors you get with dynamic data sources and the Web.Contents function in Power BI (see here and here for example). Recently I learned about an interesting new detail regarding this problem that I thought was worth blogging about, and which

The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release.  This feature should be considered essential to anyone who is regularly working in the Power BI space.    In this article I recommend my top five External Tools, that I [...]Read More »

One thing I tell people over and over again, is that if you want to learn to be good using Power BI, you have to practice. One of the best ways to practice is to find a topic you are interested in and build something useful. River Murray Floods 2022 [...]Read More »

First, an intro from Matt.  I have only met Daniel Duque via LinkedIn.  Daniel contacted me last month with the kind message below.  He wanted to write a book review and was looking for suggestions on where to do this.  I suggested he write it here on my blog, hence [...]Read More »

A colleague of mine came to me with an interesting use case, “ Switch between a summarized value or selected value with multiple legends”. For example, I have five countries… The post Switch between a summarized value or selected value with multiple legends appeared first on Prathy's Blog....