This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 13%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi,
I am new to SSAS tabular model. I am creating cubes in SSAS with Hana data source. Data is in text format in power query editor from SAP hana. I am converting to Date format. Data looks good in power query editor. When I import to SSAS by "close and apply" I get the below error message.
"Failed to save modifications to the server. Error returned: 'The following system error occurred: Type mismatch Datatype conversion failed for [Table:****]"
Has anyone had this problem and what is the solution?
Thanks in advance
Suganya
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Not sure if this thread can help you.
Best regards,
Percy Tang
Thanks, Percy for your reply.
I am trying to convert the data in query editor and import to SSAS tabular model. I haven't deployed the model to workspace server as mentioned in the link. That did not solve my issue.
Thanks
Suganya