Forum Discussion
Sage 50
Hi RWalsh
You could connect to Sage 50 UK as an ODBC Data Source with Power BI Desktop.
For more information, please check the links here:
Using Microsoft Power BI with Sage Intelligence Reporting
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I've recently documented how I got the ODBC driver working with on sight Sage 50 and the powerBI personal gateway for schedule refreshing. Take a look at the link for the full details.
https://www.osinsci.xyz/data-analysis/linking-sage-50-to-powerbi/
Hi OSin,
I am currently undertaking exactly this project so this link would be helpful but unfortunately it seems to be inactive. Any chance you still have this documentation on hand?
Would also be good to know if you had any advice on how to explore the Sage database before importing? In the accepted solution answer the document notes you can use a SQL statement using the ODBC connection in PBI Desktop however my understanding is that the Sage 50 database cannot be interogated using SQL. Any work around/advice for this?