Hi,

Actually, you can set up Sage Intelligence reports to run automatically to Power BI through One Drive.  The Connect can be used to add tables and expressions to existing reports or to create new Sage Intelligence reports then set the report up to be sent to PowerBI.  Here are a few links to help but let me know where I can assist with this further. 

Getting Started with Sage Intelligence and Power BI: http://int.elligence.co/webcast/PowerBI/Gettingstarted

Learn how you can create informative dashboards with Sage Intelligence and Power BI: http://int.elligence.co/SageIntelligence/DashboardswithSI&PowerBI 

Discover the convenience and benefit of using Microsoft Power BI with Sage Intelligence Reporting: https://youtu.be/zFincW1u84U

And also:

Learn how to connect multiple data sources using the Connector Module: http://int.elligence.co/SageIntelligence/connecttomultipledatawithconnectormodule

I most important questions I have currently is 

1) Can I link to ANY Sage 100 table via odbc.  When I look at Sage Intelligence, the Sales Fields are limited.

2) If I want to link to two of our companies, does that mean I HAVE TO have Connector.

Thank you so much for your assistance,

P.Park

1) yes, you can link to any tables as long as the tables relate to each other. 

2) yes, you need the Connector to report on two different companies/databases. 

Thank you Sandra.  I have been watching a ton of videos and am learning a lot.  I am testing this with PowerBI, OneDrive, and of course SI.  I am able to import the xlsx file to BI via Onedrive, but can't do it automatically.  I have scheduled the report to export from SI to my shared OneDrive folder, but there the chain of uploading stops.  Any ideas?

Thanks much!

Paula

Hi Paula, 

Sorry for the delay.  We have a few videos on this subject.  I have one of them below but if back out of the link below to other webcast links you will see the others. 

Are you are referring to the update between OneDrive and PowerBI or the Auto distriibution feature in Sage Intelligence?  You need to set up the auto update within PowerBi to Onedrive.  I can search online for how to do that if you cannot find it.  If you are having trouble with the Auto Distribute feature with Sage Intelligence then please let me know what, specifically, is the problem 

Link to latest PowerBI video: http://int.elligence.co/SageIntelligence/DashboardswithSI&PowerBI

Getting Started with Sage Intelligence and PowerBI http://int.elligence.co/webcast/PowerBI/Gettingstarted

Sandra.