Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Can't separate a field by delimiter while using direct query

Hi Everyone,  Hoping for a solution to this one. I have a field coming from a sql server using direct query that looks like this: 001|568|222|448|78456|1145 I  need to find a way to seperate ea...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    The sql function you refer too would create many new rows of data, I am looking to split the Path into columns. Do you have any other recommendations?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Just so I'm clear on the direction i took. I did not find a solution to perform this task with direct query. I ended up changing connection type to Import in order to gain full dax andpowerquery functionality. 

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

If you import the data into Power BI, the best place to split the data into multi columns is using the query editor.