split by delimiter

[MP_123]

hi,

i want to split column by delimiter (to an unknown number of rows)

i can't do it on power bi because the table is very big and this function is not supported on direct query

is someone have a way or function to do this? my DB is SQL Azure Data warehouse

thanks!

[Eric_Zhang · Accepted solution]

@MP_123

Have you tried the split function in T-SQL?

If you encounter any performance issue, I'll suggest you re-model your dataset, say create an extra table that has the data split and use this table in your Power BI report.

[Eric_Zhang · Accepted solution]

@MP_123

Have you tried the split function in T-SQL?

If you encounter any performance issue, I'll suggest you re-model your dataset, say create an extra table that has the data split and use this table in your Power BI report.

[Phil_Seamark · Accepted solution]

Or if you are lucky enough to be using SQL-2016 then you can do it natively now using

STRING_SPLIT (Transact-SQL)