Forum Discussion
OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: STRING_AGG
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.
2 Replies
Hi Anonymous ,
Based on the error message, seems like you can try to change the data type from the data source to avoid it.
Refer:
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.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:
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.
