90 Minds Community

 View Only

Excel Power Query - Setting SOTAMAS90 Credentials

  • 1.  Excel Power Query - Setting SOTAMAS90 Credentials

    Posted 02-28-2019 13:52
    Tip from Power BI presentation from @Clark Walliser.

    When connecting to SOTAMAS90 with Power Query, enter the User name as: Sage login, followed by |, followed by company code. The | in the pipe character. The image below illustrates this.

    Added benefit - These credentials are saved within the the Power Query. 




    ------------------------------
    Myron Stevenson
    Clearis Consulting
    ------------------------------