Consistent Compatability Levels SSAS & PBI Versions

You are welcome.

Please give Kudos for support.

Thanks for all your help. I will try there.

Hi I have moved Power BI model, to SSMS, and I am now trying to run the JSON DDL script and I am getting exactly the same error "The JSON DDL request failed with the following error: Unrecognized JSON property: sourceQueryCulture. Check path 'model.sourceQueryCulture', line 14, position 30.." - have you solved this yet and how

Hi I have moved Power BI model, to SSMS, and I am now trying to run the JSON DDL script and I am getting exactly the same error "The JSON DDL request failed with the following error: Unrecognized JSON property: sourceQueryCulture. Check path 'model.sourceQueryCulture', line 14, position 30.." - have you solved this yet and how

I am running the DDL in SSMS, against SSAS instance, not in VS, so I dont think I have a Tabular editor there

I am running the DDL in SSMS, against SSAS instance, not in VS, so I dont think I have a Tabular editor there

Hi Anonymous ,

have you already read and tried this?

"Thank you for your quick respond,
I did that.
I edited JSON file and I changed Compatibility Level to 1400 and then I saved it.
but when I wanted to deploy this BIM file on the SSAS server an error occurred
"Failed to execute XMLA. Error returned: 'The operation cannot be performed because it references an object or property that is unavailable in the current edition of the server or the compatibility level of the database."
but I tried another way and it worked. I don't like this way but it works 🙂
I generate the database script and then I changed Compatibility Level to 1400 in JSON file and the database name. I created new database with new Compatibility Level by executing that query."

Hi, i just tried that and now I get this

"The JSON DDL request failed with the following error: Unrecognized JSON property: defaultPowerBIDataSourceVersion. Check path 'model.defaultPowerBIDataSourceVersion', line 12, position 43.."

my property is this "defaultPowerBIDataSourceVersion": "powerBI_V3",

I guess "defaultPowerBIDataSourceVersion": "powerBI_V3", is to new for 1400?

Hi Anonymous ,

I found this one and I am afraid that the PBI data model (Power BI Desktop >= March 2020) is too current for the SSAS Tabular Server.

https://notes.mthierba.net/power-bi/xmla-endpoint/create-powerbi-premium-dataset-via-tom#create-v3-model-with-one-table

I have had a read through this, can it only be done with power bi premiuim? I dont have that. Maybe I could download and older version of Power BI, load my pbix into that?