Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
nicg
Advocate II
Advocate II

Feedback on dynamic format strings

This is more of a comment than a question.

 

We recently deployed and then reverted dynamic format strings on hundreds of measures in a large Power BI model on a P2 capacity. We discovered 2 issues that forced the reversion:

 

1. The formatting worked great in Power BI, but Excel users connecting to the model experienced timeouts and over-utilization of memory on larger queries (queries that worked without issue hundreds of times before). The same report structure that failed in Excel would return almost immediately in a Power BI matrix. I assume this is due to Excel quering in MDX, which probably doesn't handle the formatting efficiently (the Excel group really needs to dump MDX ASAP, we run into issues all the time). However, I couldn't confirm this due to issue 2.

 

2. Traces in DAX Studio or SQL Profiler no longer returned any results for queries using a dynamic format string measure. This made it very difficult to diagnose issues as they were occurring.

 

(Edit) A third issue that I forgot to mention is that, when attempting to connect to the model from SSMS and process a table/partition, an error would be thrown: "The database compatibility level of 1601 is below the minimal compatability level of 2147483647 needed for <DYNAMIC FORMAT STRING MEASURE NAME> in table <TABLE NAME>.FormatStringDefinition at PowerBI mode. (Microsoft.AnalysisServices.Tabular)

1 REPLY 1
lbendlin
Super User
Super User

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors