Forum Discussion
Sage Data Connection with ODBC
Hi markydangerous,
Have you tried to use the above Sage content pack?
Thanks,
Lydia Zhang
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
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.
Hi Dazzathedrummer markydangerous HHassan Anonymous
This is a commercial solution but is specifically designed address this very problem.
https://bi.suntico.com/blog/power-bi-accounting-data/sage-50-accounts-data-source-for-power-bi
Additionally it comes with a pre-built Power BI data model and template file
https://bi.suntico.com/go/power-bi-template-for-sage-50-accounts
I hope this helps,
Hugh