Forum Discussion

OlapOffice's avatar
OlapOffice
Helper II
6 years ago

Consistent Compatability Levels SSAS & PBI Versions

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 ...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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