• Power BI, Sage 100, Tools needed?

    Our company uses Sage 100c 2015. Our goal is to access Invoice History and the Item tables from Sage via ODBC to Power BI. We want this to be a real time connection. We are multi-company (4). We would have people access via Terminal Server. It's my…
  • report from excel container, only runs if workbook open

    Running Sage 2017 SP1, with Excel Container I have created an excel link for a large report that I'm going to pull several small reports from for distribution. This runs perfectly if the linked excel report is open but not if it's closed. I will…