Forum Discussion
Convert huge text into light data type
I have a huge text column (Visits) in my fact table which I need to later use for a distinct count measure in the report. This column (Visits) has a lenght of 37-40 characters. It is so big that ...
- Do you need to have the text column to read or just to do a distinctcount?
- Where is the data coming from?
Presuming you don't need to read. If the data is coming from a database that supports SQL, then create a statement that distinctcounts this coulmn to get the amount you need.
If it's an Exceel for example. Create the index then delete the column.
If you need to read, create a dataflow. Depending on your company's licence, Turn on Enhanced compute engine settings in the refresh part and then connect with direct query