Skip to main content

Hello,

 

I was trying to create new tabular model based off the existing sales one. I was trying to add a new IAL to the tabular model and was able to create the data source and add the data source to the tabular model.  I did set up some relationships between my newly created IAL data source and one of the existing tables in the tabular model However, When I get deploy the tabular model, I’ve been running into this error: REQUEST: 25203 SSISERROR: Analysis Services Execute DDL Task - SSAS:Error: Execution of DDL failed.

 

I was wondering if anyone else has seen this error and if anyone was able to get around this? I was wondering maybe I missed a step in the process? Thank you.

Hi,

I have successfully created new tabular models, containing data sources based on IALs before and have not seen such error.

If you can share screen-prints of your new tabular model, it might help.

Anyhow, I would deploy every time I do something (for example, first just with my custom data source , (which I believe you have already tied against a standard tabular model), then adding the standard data source, then after adding the relationship etc) and check the result in SSMS and maybe also in excel/power BI for data, so I will know at what point it fails. This has helped me with troubleshooting in the past.

Hope this helps

Asanka

Hello ​@AsankaGaru 

 

Thank you! I appreciate the quick response! I found that starting with the IAL I made first and then adding the standard objects helped me out quite a bit. I’m still playing around and understanding this but this definitely gives me a step in the right direction. 

Reply


Terms & ConditionsCookie settings