We use a Gateway in several Flows to connect to a local SQL server for SQL operations, but haven't used it for Analysis Services. Is your problem in finding the Gateway, or connecting Analysis Services? I recall it being a little tricky to configure the credentials correctly, but once set up it works dependably.
------------------------------
Jeff Woodard
Chief Technical Officer
Transportation Financial Services, Inc.
West Palm Beach FL
(561) 832-3110
------------------------------
Original Message:
Sent: Jul 26, 2022 04:26 PM
From: Eric Miller
Subject: Analysis Services Connector
Hi!
I'm trying to create a SQL connection for a Power Automate Cloud Flow that connects to an Analysis Services Server. I already have a gateway set up, but I have not been able to connect to it. Is this possible in Power Automate?
Thanks!
E.
------------------------------
Eric Miller
Lumbermen's Merchandising Corp
Wayne PA
4146282703
------------------------------