Forum Discussion
Solved
using TMDL to create a PQ calendar table error: db compatibility level of 1550 below min of 1567
I am using the March 2025 release (latest) of Power BI Desktop, with the TMDL view option enabled. I have a model with a Power Query generated calendar table that I want to copy to another report. I...
FYI, I finally found solutions to both of the issues:
- To raise the compatibility level from 1550 to above 1567 simply create a dummy calculation group and turn on the slider "Dynamic Format Strings". The level then becomes 1601.
- The "...unsupported partitions.." error happens when the model does not already contain a PQ query. Workaround: create a dummy table with the "Enter data" feature.
With that, applying the TMDL script - which was obtained from another model - works without issue.
FYI, I finally found solutions to both of the issues:
- To raise the compatibility level from 1550 to above 1567 simply create a dummy calculation group and turn on the slider "Dynamic Format Strings". The level then becomes 1601.
- The "...unsupported partitions.." error happens when the model does not already contain a PQ query. Workaround: create a dummy table with the "Enter data" feature.
With that, applying the TMDL script - which was obtained from another model - works without issue.