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.

 

Thanks

Mark

Need Help

6 Replies

  • 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