All,
I have a report that connects to Teradata. The report works perfectly fine in Power Bi Desktop using direct query. However, when I publish the same error in Power Bi Service (created a gateway entry), I get a "data source access error". Further drilling into the error message sometimes shows "Couldn't retrieve the data for this visual. Please try again later." or "unable to convert M query for table < > into Native query"
Also, when I look at the gateway logs, I see this error in the Query Execution report -
"82372fab-55f9-4cfa-bb4c-4d1726e06f13,decd9597-78a1-554b-0be4-8d825f991d6f,"[""{\""kind\"":\""Teradata\"",\""path\"":\""****.com\""}""]",6abb5dac-b955-4d6c-8411-af877a7963f8,2020-11-20T22:33:25.0360684Z,2,DirectQuery,,,,,,,N,"[Teradata Database] [3707] Syntax error, expected something like an 'EXCEPT' keyword or an 'UNION' keyword or a 'MINUS' keyword between the word 'ADVANCED"
82372fab-55f9-4cfa-bb4c-4d1726e06f13,b57fd155-328a-4e07-87a5-e5dc4af8e5c3,"[""{\""kind\"":\""Teradata\"",\""path\"":\""****.com\""}""]",d8c24f1b-b81b-4dc1-ad78-d6379b59c796,2020-11-20T23:49:36.6239383Z,1413,DirectQuery,1382,,,,,,Y,
However, it doesn't show me the full SQL to see what syntax it is complaining about. Any ideas on further troubleshooting this?
