Power Platform, API & Snowflake

Power BI
1

Hey All,

I have a use case with following steps (enterprise scenario).

  1. Business User enters Client Name in the Power App and clicks “Search” button
  2. This triggers Power Automate flow to get data from 3rd party API
  3. API Output (list of potential matches of Clients) is written to Snowflake
  4. This API Output (list) is displayed in the Power App as a gallery/list

Here comes the fun part:

  • I am not allowed to use Snowflake connector in Power Automate, instead I need to use ODBC Driver to connect Power Automate with Snowflake so I am able to write API output to the database
  • Ideally I would like to be able to run it asynchronously (so multiple users could search for clients and these queries would be run in parallel instead of queue)

I was told that I would need the Power Automate Unattended license (approx $2k/year) and Virtual Desktop, is that true? Couldn’t this be achieved with lower/cheaper license? Does someone have different idea how this could be done?

Thanks a lot!

1 Like
2

Hello @lennie.hoppe, and thank you for starting a conversation on Enterprise Pricing and Licencing options. I guess one always shares in the moment, “Is this for real?” Unfortunately, Opinions and Estimates rarely beat a Quote, and in this case, Licensing is very specific.

More details around pricing and capabilities of standalone plans can be found in Microsoft Power Platform Licensing Guide published in May 2023. A copy is uploaded to this reply for your reading pleasure.

Power Platform Licensing Guide May 2023.pdf (627.1 KB)

As soon as practical, if you have not done so already, consider reaching out to Microsoft Sales for end-to-end guidance and pricing. Microsoft Sales can be reached by Chat and Phone at the following URL or by telephone at 1-855-270-0615.

Additional related information:

• Microsoft Power Platform guidance documentation

• Microsoft Power Automate pricing page

• Overview of Power Automate licensing - Power Platform | Microsoft Learn

• Buy Unattended add-on

3

Got it - thank you @ystroman! I am just wondering if there’s anyone who had similar use case.

My main question is around if we need the unattended license, why the whole flow cannot be run in the cloud? Is it because of the ODBC driver that makes it mandatory to run the flow on the desktop (instead of in the cloud/web)?