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
OlapOffice's avatar
OlapOffice
Helper II
6 years ago

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's avatar
mwegener
Most Valuable Professional
6 years ago

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

 

  • OlapOffice's avatar
    OlapOffice
    Helper II
    6 years ago

    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's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi OlapOffice ,

       

      maybe activating this setting will help.

      • OlapOffice's avatar
        OlapOffice
        Helper II
        6 years ago

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