[Stackoverflow] [Progress OpenEdge ABL] ODBC Connection with OpenEdge and Power BI

Status
Not open for further replies.
R

Raphael Frei

Guest
I'm having some issues while connecting from OpenEdge ODBC and Power BI.

The issue isn't in the connection, but on SQL parameters.

What I have tried so far:

  • Connecting without SQL Parameters, but I'm having the 'COLUMN at TABLE has value exceeding its max length or precision.

  • Connecting with this SQL: SELECT ta1, ta2, ..., tan FROM PUB.Table but this is causing the 'Expression.Error: The key didn't match any rows in the table. '.

  • Searching the forums, I've find to try the statement OpenQuery - So SELECT * FROM OpenQuery(MyDB, 'SELECT ta1, ta2, ..., tan FROM PUB.Table') or SELECT * FROM OpenQuery(MyDB, 'SELECT "ta1", "ta2", ..., "tan" FROM PUB.Table'), this is causing 'Table/view/synonynm "SYSPROGRESS.OPENQUERY" cannot be found. (15814)'.
    (Tried to insert PUB on a few places in the query, but didn't work either)

  • Another attempt - SELECT (SELECT ta1, ta2, ..., tan FROM Pub.Table) as MAIN is causing 'Too many values specified(7531)'

    The idea to use the SQL is to remove the table that is exceeding the max length, because it's not required to the Power BI's graph.

Any sugestions? Thanks!

Continue reading...
 
Status
Not open for further replies.
Top