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
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.