hi

[abc_777]

hi,

am i not sure its and excel work or i can do it using power bi. 

We have same invoice number for multiple product bar code. as per following view. 

i want to arrange Invoice_no and user_barcode side be side with same invoice number. 

i.e

invoice_no                USER_BARCO

2016078182442-       36004, 36005

2016070116825-       10009, 10011, 10012

2016070116700-       10001

like this format. 

i have more than 5 million data to do please advise the best and quick way to achive this

thanks

[ThxAlot]

Given the magnitude of the recordset, it's worth trying the new, native T-sql function STRING_AGG instead of PQ.

STRING_AGG (Transact-SQL) - SQL Server | Microsoft Learn

[Ahmedx]

I have no knowledge in MSSQL

[abc_777]

its k man, thanks again you helped me a lot

[abc_777]

Hi   @Ahmedx 

 the magnitude of data set would be two columns product name and Invoice_no with 3 million of rows or data

can i do the followng code at MSSQL rather using power bi. so work would be much easier.

If so pelase instruct me how and the syntex. 

= Table.Group(Source, {"INVOICE_NO"}, {{"Count", (x)=> Text.Combine(x[USER_BARCC],", ")
}})

thanks man

u help me a lot

[Ahmedx · Accepted solution]

pls see my video

multiple product.mp4

= Table.Group(Source, {"INVOICE_NO"}, {{"Count", (x)=> Text.Combine(x[USER_BARCC],", ")
}})

[abc_777]

@Ahmedx 

one last thing after convert user barcode how i can i export data to csv from power query as its a large data set of 50,00,000. i tried dax studio it can do only upto 4,00,000 how i can take full data

thx

[Ahmedx]

you may have to split the table into several parts with the help of Table.Range() and then export with the help of Bravo for Power BI . this tool can export up to 1 million

[abc_777]

I tried bravo but no luck. its not getting data from powr bi query that we converted barcode as row wise. 

bravo actually takes power bi visual data as raw. so not helpfull for me.

but its ok thanks man for your time and if u have any eazy solution to export the query that you shoed me to csv file please help me.

thanks again

[Ahmedx]

pls see this
https://youtu.be/0a4tKrakZiE

_________

https://community.powerbi.com/t5/Desktop/How-to-export-grid-or-matrix-with-15-20-columns-and-more-th...

[abc_777]

thanks man.

really apriciate