Thanks Gabrielle - I think honestly the easiest thing to implement would be to just highlight the VARCHAR(xxx) value in the Save Data part of the data flow, option 2 I was just spitballing. I'd also question the design choice of Right Click > Convert to Text in a data flow defaulting to Cast(column as varchar(4000)) as…

In case it helps someone else; we have a data set that helps us to identify this issue on a temporary basis by creating a data set using the below SQL. This is helpful but still needs a data set to be created first which can waste time - a proper solution is still needed on the front end. select c.TABLE_NAME,…

This is a good idea, and should be fairly simple to deliver.

It's particularly useful with ERP reports when you want to put the dashboard read only, and you want to send out to someone senior who doesn't need to know about having to change filters. In that case you can simply put trailing period to 0 and it will always show them the current month's data, and you can use a FILTER…

These are very useful in ERP and should be standard across the application.