cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP_123 Member
Member

split by delimiter

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!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: split by delimiter

@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.

View solution in original post

Phil_Seamark Super Contributor
Super Contributor

Re: split by delimiter

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

 

STRING_SPLIT (Transact-SQL)

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Moderator Eric_Zhang
Moderator

Re: split by delimiter

@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.

View solution in original post

Phil_Seamark Super Contributor
Super Contributor

Re: split by delimiter

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

 

STRING_SPLIT (Transact-SQL)

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 68 members 1,016 guests
Please welcome our newest community members: