Fix LISTAGG columns being read out of Snowflake

[Anonymous]

When reading a column formed in a view as a LISTAGG() function in snowflake, when Power BI reads the field(assuming that record has multiple values), it reports it in every order possible of the individual items, while Snowflake only displays one value for it, causing count mismatches when doing QA scripts. 

[Anonymous]

Hi  @Anonymous 

So you use LISTAGG() in Snowflake and then through Power BI Desktop to get data from Snowflake ,right ? You mentioned that in PBI Desktop , LISTAGG() returned multiple values but in Snowflake , it just displayed one value . What should be the correct outcome ? Can you provide more detailed info for reference ?

Best Regards,
Community Support Team _ Ailsa Tao

[Anonymous]

Hi @Anonymous 

you are correct. I have views built in Snowflake with ListAgg() and I consume the views in Power BI Desktop and Service. 

if I compare a table with all columns in Power BI to a select * from Snowflake, Power BI makes more records. The correct outcome would be for Power BI to have one record, matching the output of the Snowflake view.