Query about importing data with SQL and separating data into a column

[Syndicate_Admin]

More than a problem is a query:

I am preparing a dashboard connecting by directQuery to a database that is updated at all times, the database has information since 2010, it is immense; Through the help of forums I have managed to import the data to power bi only from the year 2021 (using a SQL query)

when I charge the data table the last column has clustered data, separated by comma, for example (value1,value2,value3,........ value21)

Based on your experience: can you separate that last column using a SQL function by simply entering the function in the power BI box?

in other words: I connect to the database and enter the first query that filters the data only of the year 2021 and also could I enter a function that separates the last column into several columns?

has anyone done this? or just the sql box that power bi brings is for more basic things like filtering by dates only? which is something I've already done

I hope someone based on your experience feed me back, thank you!!

note: the problem of separating the last column into several being within power BI is easy, in the icon of transform data there is an option to perform this action, which I am consulting if it can be done before entering a sql function in the data load box

[CNENFRNL · Accepted solution]

You might find something interesting by googling "SQL SPLIT COLUMN"; but it's obvious that PQ is more competent in such a job.

[v-janeyg-msft · Accepted solution]

Hi, @Syndicate_Admin 

What is entered in this box is sql syntax. You can reference the tutorial:

How to split a column with delimited string into multiple columns in Sql Server - DataMajor

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL · Accepted solution]

You might find something interesting by googling "SQL SPLIT COLUMN"; but it's obvious that PQ is more competent in such a job.