Forum Discussion

analitika123's avatar
analitika123
Helper II
2 years ago

Getting error( whyile refreshing PBIX file OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [080

Hi,

 

I am an error this when I rry tto reresh data.

OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [08004] [SAP][ODBC Driver][SQL Anywhere]Parse error: Missing '=' near '};'.

 

How I could resolve this issue?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi analitika123 ,

    Based on the error message you've shared, it seems like there might be a syntax issue within your connection string or query that's causing the ODBC error. This error typically indicates a problem with how the connection string or query is formatted, particularly around the area it mentions "Missing '=' near '};' ".

     

    Please below steps:

    1. Review Connection String: Check your connection string in the Power BI data source settings. Ensure that all parameters are correctly formatted and that each parameter name and value are properly separated by an '=' sign.

     

    2. Query Syntax: If your connection string appears correct, review the query you are using to fetch data. Look for any syntax errors or misplaced characters, especially around the area mentioned in the error message.

     

    3. Update ODBC Driver: Ensure that you are using the latest version of the ODBC driver for SAP SQL Anywhere. An outdated or incompatible driver version might also lead to such errors.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.