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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
OlapOffice
Helper II
Helper II

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

19 REPLIES 19
KamilSzpyrka
Helper III
Helper III

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?

Hi @OlapOffice ,

 

take a look at the tabular editor

https://tabulareditor.com/

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


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.

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

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


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": [
{

Hi @OlapOffice ,

 

maybe activating this setting will help.

TabEditorSetting.png

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


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

Hi @OlapOffice ,

 

maybe they can be helped directly here.

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

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Thanks for all your help. I will try there.

Anonymous
Not applicable

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
Not applicable

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

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Anonymous
Not applicable

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

Anonymous
Not applicable

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

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

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Anonymous
Not applicable

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?

You are welcome.

Please give Kudos for support.

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Anonymous
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.