Hello, I am using the Power bi Desktop version, when I am trying to connect to Sage 50 accounts by using the ODBC, it dilog is showing all the tables but when I am selecting the tables it is giveng error as follows :
Please help to make report from Sage ODBC. Thanks,
@arijit This could be an issue with ODBC driver itself. Why do you need to use ODBC ? Can you not connect straight to database using default database connector within power bi such as for sql server or oracle ?
@arijit You may be interested as well, last week I published a Content Pack for Sage 50 Accounts. You can find it on Power BI Service, under Get Data > Services.
You can also use the same credentials to pull the raw Sage 50 data into PBI Desktop.
At the moment the data feed is pulling mainly sales-related information because that is the topic of the Content Pack. We have plans to extend that.
Excuse the self promotion, but I thought you might find it useful. You can also see a quick video here. https://www.suntico.com/bi/
The mystery is the version of SQL. Sage 50, unlike 100 and 200, uses a version called Pervasive SQL. Microsoft Power BI can't use that.
Suntico (see posting elsewhere on this thread) do seem to have cracked that - but you would need to have a good look at their pricing, especially as you would probably need a number of Pro licences too.
I set up a script that will let you post the Sage data to an SQL db on a schedule without the SDK or expensive connector, please see my post here:
From here you could connect it to PowerBI