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

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.

Reply
eilmrein
Regular Visitor

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-Project
4. Compiling a pbit file from the modified directory using pbi-tools

5. Opening this pbit file

 

All partitions have a source of type m in the json file.

 

Any ideas?

3 REPLIES 3
MRIZ
Helper I
Helper I

Hi, I have come accross with the same issue. getting error . I extracted SSAS model using Tablar Editor. I converted Model.bim file to .PBIT file. Now opening it on Power BI giving me below error. plz help

MRIZ_0-1700148094481.png

 

eilmrein
Regular Visitor

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"
              ]
            }
          }
        ],

 

 

 

v-tangjie-msft
Community Support
Community Support

Hi @eilmrein ,

 

Based on the error message, it seems that all partitions have a source type "m" in the JSON file, which is not a recognizable partition source type in Power BI. The most common types of partition sources are SQL, Oracle, Text/CSV, and Web.
You can try:
1. Modify the partition source type in the JSON file to a recognized partition source type.
2. Check the model.bim file for corruption.
3. Try deleting and recreating the partition in Power BI.
4.Try creating a new Power BI report and importing the model into it.
Also, make sure that you have followed the correct steps to modify and compile the pbit file using pbi-tools. Double-check that the modified JSON file is saved correctly and that the pbit file is compiled correctly.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.