OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: STRING_AGG

[amaan91]

Hi All 
One of my report suddenly started throughing the below error and is not allowing the report to refresh. 

its a simple Azure connect to a view, 
i have tried to make all the the changes in the power Bi interface but i have feeling it got to do with the SQL code used to generate the view .
The key question i have is i use the same connection to access this view in other reports but this error is not occuring there. 
would be great if some one who has faces something similar can help me our or point out if i am missing out on someting obvious. 

[Syndicate_Admin]

Hi @amaan91 ,

Based on the error message, seems like you can try to change the data type from the data source to avoid it.

Refer:

1. How to use the function STRING_AGG() 
2. A Couple of notes on the STRING_AGG function 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yingjl]

Hi @amaan91 ,

Based on the error message, seems like you can try to change the data type from the data source to avoid it.

Refer:

1. How to use the function STRING_AGG() 
2. A Couple of notes on the STRING_AGG function 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.