Longer String Limit for Columns
Right now the limit for characters in a column is 1024 while services like power bi are apparently well over 100k. We have columns in sql server that store things like xml logs that go over 1024 character which gets truncated. I wasn't even aware of this until now and I've been appending data since November that I've missed out on because they no longer exist in the database.
I'm proposing a higher limit than 1024, thanks .
Also does a warning exist that I have missed seeing? I'd like to be notified or be able to search for columns that are being truncated that I may not know about.
Workaround for some:
Assuming your data isn't super long you could always slice the data in SQL in the query using a SUBSTRING function. Not sure this is very feasible in my case as my max length is 17,314 characters which would result in 17 columns but if you're just over the limit it's an option.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board