Forum Discussion

markydangerous's avatar
markydangerous
Regular Visitor
9 years ago

Sage Data Connection with ODBC

Has anyone had success connecting Power BI desktop to Sage 50 via ODBC? i have managed to get to the point where i can see the tables but not access them.   Any help would be appreciated.   Thank...
Need Help
markydangerous's avatar
markydangerous
Regular Visitor
9 years ago

Hi Lydia,

 

Thanks for the reply. I have been using the Sage v23 ODBC driver to attempt a connection. The cdata driver connects through sdata and can be slow so i am attempting to go straight there using the local path name.

 

Here is the error message:

DataSource.Error: ODBC: ERROR [42S02] Table not found
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=SageLine50v23
    OdbcErrors=Table

Sage support have suggested there should be a way to send the serial and activation key from Power BI to sage to allow 3rd party integration but I cant work out how.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi markydangerous,

Have you tried to use the above Sage content pack?

Thanks,
Lydia Zhang

  • HHassan's avatar
    HHassan
    New Member
    9 years ago

    How to get the Sage Content Pack ?

    I checked in Power BI Desktop -> Get Data -> Online Services ... but there is no content pack for Sage. I have downloaded and installed the Power BI Desktop 32bit today (so it should be latest). Will really appreciate if any one can address the problem. Thanks

     

    Error:

    DataSource.Error: ODBC: ERROR [42S02] Table not found
    Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=Sage Line 50 v23
    OdbcErrors=Table