Press "Enter" to skip to content

Day: December 30, 2024

Recovering Power BI Reports and Semantic Models

Published 2024-12-30 by Kevin Feasel

Kurt Buhler saves the day:

In the Power BI service or Microsoft Fabric, you might encounter situations where you can’t download a report or model from a workspace. Depending on your workflow, this could be problematic; for instance, you might need to work further on this file in Power BI Desktop. To do that, you first need to recover a Power BI Desktop (PBIX) file or the newer format, Power BI Projects (PBIP).

Read on for several reasons as to why you might not be able to download the file, and what you can do about it, using the semantic link library and semantic-link-labs.

Leave a Comment

Shared Semantic Models in Power BI

Published 2024-12-30 by Kevin Feasel

Soheil Bakhshi shares some data:

This blog series complements a YouTube tutorial I published earlier this month, where I quickly covered the scenario and implementation of shared semantic models in Microsoft Fabric. However, I realised this topic demands a more detailed explanation for those who need a deeper understanding of the processes and considerations involved in one of the most common enterprise-grade BI scenarios.

Read on for part 2 of this series. Soheil also includes a link back to part 1 if you missed it.

Leave a Comment

The Year in DAX: 2024 Edition

Published 2024-12-30 by Kevin Feasel

Marco Russo wraps up the year:

In 2024, DAX added several functions to support visual calculations – a Power BI feature still in preview at the end of the year 2024. These 12 functions cannot be used in measures, calculated columns, nor calculated tables – they can only be used in visual calculations: COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL, FIRST, ISATLEVEL, LAST, MOVINGAVERAGE, NEXT, PREVIOUS, RANGE, and RUNNINGSUM.

Read on to learn more about what Microsoft has done with DAX as a language, as well as what has kept the SQLBI team busy and what’s coming in 2025.

Leave a Comment

PostgreSQL and Indexing on EXTRACT()

Published 2024-12-30 by Kevin Feasel

Henrietta Dombrovskaya troubleshoots a performance problem:

It’s Christmas time and relatively quiet in my day job, so let’s make it story time again! One more tale from the trenches: how wrong you can go with one table and one index?

Several weeks ago, a user asked me why one of the queries had an “inconsistent performance.” According to the user, “Sometimes it takes three minutes, sometimes thirty, or just never finishes.” After taking a look at the query, I could tell that the actual problem was not the 30+ minutes, but 3 minutes – when you have a several hundred million row table and your select yields just over a thousand rows, it’s a classical “short query,” so you should be able to get results in milliseconds.

Read on for the problem, as well as how Henrietta was able to coerce the PostgreSQL optimizer into choosing the correct path.

Leave a Comment

Microsoft Fabric and Power Platform Resources

Published 2024-12-30 by Kevin Feasel

Jon Voege has a collection of links for us:

This week, to round off the year, we try something different. I wanted to throw a shout out to all the community heroes out there, who also help make the most of Microsoft Fabric, through the use of Microsoft Power Platform (and vice versa).

Also, I wanted to highlight some of their contributions, and hopefully give you all a list of resources to peruse.

Click through for more than 20 links, showing how you can work with Power Automate, Power Apps, Power Pages, and data in Dataverse from Microsoft Fabric.

Leave a Comment