Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |