Forum Discussion

eilmrein's avatar
eilmrein
Regular Visitor
3 years ago

Partition Type 'M' not supported

I am getting this error after doing these things: 1. Create an empty PBIX file 2. Extract the model from it using pbi-tools extract 3. Overwriting the database.json with a model.bim from a SSAS-Pr...
Need Help
eilmrein's avatar
eilmrein
Regular Visitor
3 years ago

Hi,
When I export a model from Power BI using Tabular Editor (2.17.3) I get the following partition definition for a table:

 

       "partitions": [
          {
            "name": "Fronius-97d190ea-8d10-4855-a837-53fbaa86acdf",
            "mode": "import",
            "source": {
              "type": "m",
              "expression": [
                "let",
                "    v_froniusdata_View = HouseDB{[Name=\"v_froniusdata\",Kind=\"View\"]}[Data]",
                "in",
                "    v_froniusdata_View"
              ]
            }
          }
        ],

 

When I use this file instead of the one taken from SSAS, everything works as expected.
Looks like there is a versioning conflict somewhere....
The SSAS model is CompatibilityLevel 1500 whereas the Power BI exported file is 1567

The partitions definition in the SSAS bim-file looks like this:

 

 "partitions": [
          {
            "name": "Partition",
            "dataView": "full",
            "source": {
              "type": "m",
              "expression": [
                "let",
                "    Source = #\"SQL/10 35 11 133;DATAMART\",",
                "    dbo_Dim_External_IC_DM = Source{[Schema=\"dbo\",Item=\"Dim_External_IC_DM\"]}[Data]",
                "in",
                "    dbo_Dim_External_IC_DM"
              ]
            }
          }
        ],