question

ovonemty avatar image
0 Votes"
ovonemty asked CarrinWu-MSFT commented

Failed to save modifications to the server. Error returned: 'Unable to convert a value to the data type requested...

I am trying to add a table in SSAS (using visual studio) and I get this error:
122636-image.png




My guess is that SSAS somehow decides that SegKey is an integer, and at some row it breaks, because the said row is not an integer...

But while importing the table I dont get any option to select data types... How can I consume this table?

sql-server-analysis-servicesvs-extensions
image.png (31.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ovonemty, we have not get a reply from you. Did below answer could help you? If yes, please do "Accept Answer". If not, please feel free to let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @ovonemty,

Welcome to Microsoft Q&A!

The data type cannot be changed only if you import data successfully. Could you import data successfully if you do not select the mismatch column? If not, please share your Compatibility level and SQL Server version. There have some differences when you add/get data into SSAS, please refer to below links:
Get data (Compatibility level: 1500)
Lesson 2: Add Data (Compatibility level: 1200)


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.