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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi markydangerous,

What is the error message that you get when loading table to Power BI Desktop? Do you follow the guide in this blog to connect to Sage 50 from Power BI Desktop?

In addition, there is a content pack for Sage 50 in Power BI Service,  you can connect to it via Get Data > Services entry. For more details, please review this video:https://www.suntico.com/bi/.





Thanks,
Lydia Zhang

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

      • Dazzathedrummer's avatar
        Dazzathedrummer
        Frequent Visitor
        9 years ago

        Hi, 

        Im getting the same error as this while trying to use Sage ODBC for Pbi and Excel.

         

        Would love to know how to fix this ifanyone has a solution.

        I'm not sure that a content pack will provide any kind of a solution as the problem is with the ODBC connection itself.