Connecting to Sage MAS 90/100 with PowerBI Gateway?

[Hikmer]

Anyone know if there is a way to connect PowerBI Desktop or Gateway to Sage MAS systems without using a clumsy OneDrive approach? 

[doofy2023]

Yes i have a script that will update mas90 from odbc to wsql , as well as ssis packages to seed the first round of data , then from there gateway to powerbi

[s-roberts]

Did you resolve this? We are having issues connecting PBI to Sage 100 cloud. The local Odbc connection works on the desktop but when published to the service (using gateway) it's not working.

[doofy2023]

EMAIL ME @mdorfman@galaxyee.com , i have scripts to to seed data into sql and then do a import every 5 mins 

then easy jump from sql to power bi 

[Seth_C_Bauer]

@Hikmer Have you looked into building your own custom connector? info

[Hikmer]

No, that is far too much work. However, we had success setting up an ODBC connection with the personal gateway, so I expect this to work with the enterprise gateway as well. Still testing.