Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

panidepus

Syntax error, expected something like a name or a Unicode delimited identifier

Submitted by on ‎01-08-2018 02:43 PM

We are getting the following error when we run a report against Teradata. Some of the queries are running fine. The gateway is established and it was working fine. These reports were developed 2 months back and until now there is no issue with these reports. It is seems PBI is passing the wrong SQL statments to teradata with syntax errors in it.

   

Get the following error from PBI and we see the missing SQL statement like  "("  and some missing joins etc,

Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or a 'SELECT' keyword or '(' between '(' and the 'UNION' keyword.

 

Any help would grealtly apprecited.

 

Thanks

Pani

Status: Needs Info
See more ideas labeled with:
5 Comments (5 New)
Comments
panidepus
Regular Visitor
‎01-08-2018 02:26 PM

We are getting the following error when we run a report against Teradata. Some of the queries are running fine. The gateway is established and it was working fine. These reports were developed 2 months back and until now there is no issue with these reports. It is seems PBI is passing the wrong SQL statments to teradata with syntax errors in it.

 

Get the following error from PBI and we see the missing SQL statement like  "("  and some missing joins etc,

Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or a 'SELECT' keyword or '(' between '(' and the 'UNION' keyword.

 

Any help would grealtly apprecited.

 

Thanks

Pani

v-qiuyu-msft
Community Support
Community Support
‎01-09-2018 10:20 PM

Hi @panidepus,

 

Did the issue happen in Power BI service? Please try to download the report from Power BI service then refresh data in Power BI desktop to see if the same error occurs. 

 

When you open report in desktop, please check which query used to get data, you can show the statement if possible. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎01-09-2018 10:23 PM
Status changed to: Needs Info
 
panidepus
Regular Visitor
‎01-10-2018 05:50 AM

Thank you for responding. There is no issue with Power BI desktop. The same reports are running with out an issue. Basically, many reports passing thru Gateway servers is an issue.

 

I found out the following but the instructions are not clear with MSOLAP.5 regestry instructions:

 

https://community.powerbi.com/t5/Service/there-was-a-data-source-access-error-Please-contact-the-gat...

 

https://community.powerbi.com/t5/Service/there-was-a-data-source-access-error-please-contact-the-gat...

 

Thank you for any insight.

panidepus
Regular Visitor
‎01-10-2018 06:01 AM

It seems the issue is with the Gateway server, I am assuming while SQL passthrough the gateway server is messing it up. We restarted the gateway service and rebooted the server and also we keyed in the credentials again in the gateway connection etc but no luck!. It is for sure to do something with the Gateway.

Idea Statuses