Fetching data from BI dashboard using sql query

Hey, I’m currently- want to fetch data using sql query where I’m using CTE (common table expressions) in the query I’m pulling data from two different views, when I’m putting these queries in UiPath in the run activity it’s failing saying failed to establish connection to the server. WHat shoud I do?

Hi!

Have you verified that your provider name and connection string is correct?

https://docs.uipath.com/activities/other/latest/user-guide/execute-query