I’ve finally managed to connect to Sage v50 and refresh Power BI .
This works on a verison of Sage that has been downloaded to the local machine and I have used access remote data when setting up Sage on my machine.
Once I had the Sage App set up on my machine, the ODBC connectors were installed in Excel and in Power BI.
Excel uses 32bit, Power BI 64 bit.
Start in Excel and create a connection to Sage - I’ve attached screenshots of the connections for both Excel and PowerBI. Once you have set up your ODBC connection in Excel, use Microsoft Query to specify the tables - I followed this post step by step:
When you have created your query, copy the SQL code and set up the ODBC connector in Power BI - make sure you hit advanced and paste in your code. You should be good to go then.
When you publish to the service, you need to use a data gateway and set up the dataset.
Hi @Sue , we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
Use the forum search to discover if your query has been asked before by another member.
When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
Use the proper category that best describes your topic
Provide as much context to a question as possible.
Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
