We have created a new solution and shared a query to see the result in powerBI.
When we are trying to access the LDS assigned to this solution, we are getting below error.
If we ran the same query in teneo, we are getting the response and same query is running fro other LDS in powerBI. please find the query below.
lu s.botname as “s:Solution”, date as “d:Date”, s.id as “s:SessionID”, s.beginTime as “dt:beginTime”, s.endTime as “dt:endTime”: catd(model=“date”) s.beginTime as date, s.transactionCount>=2, t.e.userInput!=“”, t.e.userInput!=“Generating input for alert”, t.e.userInput!=“send___parameter”
We are using the development setup.
We have verified the same and same query we are using in other solution and its working in Power BI.
Attaching the sample output of the query from the solution which is having issue in power BI.
It could be an issue with the caché en PowerBI. Could you try to follow the steps for clearing the caché described in this entry to see if that solves the issue:
Ok, then please try to unpublish all shared queries, clear the caché again, and then republish this query alone and try again to confirm that the query works on it’s own.
We tried the same but still facing the issue.
I tried one more thing where I have share new query “la. s.id” in new solution and followed the same procedure present in below url for developer setup to share and publish the query but still getting the same error.
Our teneo environement is on-prem. So I would say its on-prem endpoint.
Yes, I am clearing the cache before attempting the connection.
We can have teams/webx call and I can show you.
