Consistent Compatability Levels SSAS & PBI Versions

[OlapOffice]

I am trying to move my pbix model to a VS project in order to have some functionality that is missing in PBI Desktop. However, the compatability level available on SSAS is currently 1500 compared to 1520 on PBI Desktop. Versions of servers are different as well with the latest for SSAS being 15.0.18333.0 and on PBI Desktop being 15.1.40.25. If I try replacing a VS model.bim file and try to open in I get errors as some settings are not available. Is there to be an updated template for VS or an equivalent release for SSAS that is the same as PBI Desktop. Any suggestions would be useful.

[KamilSzpyrka]

Hello, I'm refreshing this topic to ask if anything in above subject has changed?

Can we somehow deploy  "defaultPowerBIDataSourceVersion": "powerBI_V3" to Analysis Services?

[mwegener]

Hi @OlapOffice ,

take a look at the tabular editor

https://tabulareditor.com/

[OlapOffice]

I did. I opened the PowerBI model in Tabular Editor and then saved to Model.bim file and replaced the VS model.bim file. This is where there is a difference in Compatability and settings in the later version than available through VS.

[mwegener]

I would have tried to deploy the model from the tabular editor to the tabular SSAS instance first.
PBIT -> SSAS Tabular -> VS

[OlapOffice]

Thanks for the suggestion. I get the error below.

---------------------------
Error occured during deployment
---------------------------
The JSON DDL request failed with the following error: Unrecognized JSON property: sourceQueryCulture. Check path 'model.sourceQueryCulture', line 14, position 30..
---------------------------
OK
---------------------------

{
"create": {
"database": {
"name": "TEST",
"compatibilityLevel": 1520,
"model": {
"culture": "en-US",
"dataAccessOptions": {
"legacyRedirects": true,
"returnErrorValuesAsNull": true,
"fastCombine": true
},
"defaultPowerBIDataSourceVersion": "powerBI_V3",
"sourceQueryCulture": "en-US",
"tables": [
{

[mwegener]

Hi @OlapOffice ,

maybe activating this setting will help.

[OlapOffice]

Unfortunately that did not work. I have tried different combinations to no avail.

[mwegener]

Hi @OlapOffice ,

maybe they can be helped directly here.

https://github.com/otykier/TabularEditor/issues/163

[OlapOffice]

Thanks for all your help. I will try there.

[Anonymous]

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

[Anonymous]

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

[mwegener]

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."

[Anonymous]

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

[Anonymous]

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

[mwegener]

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

[Anonymous]

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?

[mwegener]

You are welcome.

Please give Kudos for support.

[Anonymous]

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

[Anonymous]

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