Good day,
I am trying to create some PowerBI reports using the data from the Sage 50c Pastel Partner Data.
Although there are some methods that allow me to do this by exporting data manually. I am looking for an automated solution.
I have managed to set up the 32 Bit ODBC connection to the Sage data. This then allows me to import into PowerBI. However to automatically refresh this data the connection needs to be a 64bit for the Gateways to update.
I have investigated using a SQL DB as a middle man between Sage data and PowerBI by pushing the data to SQL but not sure if this is the best way forward or how to set up the connection.
Have somebody found a solution to the above that can help me?
Regards,
Wessel