Skip to main content

Notifications

Building Copilot Studio Chatbots in Microsoft T...
Answered

Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? Is it possible to get suggested topics from company internal websites?

Posted on by 7

Dear experts,

 

I'm newbie for PVA. Currently I plan to only use the free Teams version (I have office 365 license). Here are 2 questions:

1. Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? 

2. Is it possible to get suggested topics from company internal websites? I found the document mentions that when use suggested topics, the link you provided should be https, and no need login. I provided company internal websites address which are https, and no need login, but it still reports error and connection failure.

Thanks!

  • Pstork1 Profile Picture
    Pstork1 63,059 on at
    Re: Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? Is it possible to get suggested topics from company internal websites?

    If you create a bot in Teams and call a Premium connector in a flow triggered by the bot, then the flow will run in the context of the user of the bot. That means that user would need a Premium license.  The one exception to that is of course Dataverse, since that is covered by the Dataverse for Teams license and isn't Premium for either the flow or the bot when running under Teams.

  • H_Jonaa01 Profile Picture
    H_Jonaa01 37 on at
    Re: Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? Is it possible to get suggested topics from company internal websites?

    Hi @Pstork1,
    so, if I create a bot in teams, which is using premium connectors in a flow, all my users that want to chat with this bot need a premium license? 
    My thought was, that it is enough to have a premium license for the user, which is creating the bot/ flow.

  • Mary168 Profile Picture
    Mary168 7 on at
    Re: Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? Is it possible to get suggested topics from company internal websites?

    Hi Pstork,

    Got it, thank you very much!

  • Pstork1 Profile Picture
    Pstork1 63,059 on at
    Re: Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? Is it possible to get suggested topics from company internal websites?

    to use the internal website for suggested topics your best approach will be to copy the FAQ off the internal web site and into a PDF or Excel Spreadsheet.  Then post that spreadsheet somewhere accessible on the Internet.  After you import the topics to PVA you can then delete the Internet accessible file. I don't know of any other way to do it.

  • Mary168 Profile Picture
    Mary168 7 on at
    Re: Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? Is it possible to get suggested topics from company internal websites?

    Hi Pstork,

    Thank you so much for your reply! For the 2nd question, yes, the internal web site is only accessible on the internal network. Is it possible to make this kind of website workable (suggested topics) if don't want to be accessible by public network? If no, is there any best practice to make internal website be accessible by public network if security allowed.

  • Verified answer
    Pstork1 Profile Picture
    Pstork1 63,059 on at
    Re: Can free teams version PVA use Power Automate to connect to on-premise SQL Server database? Is it possible to get suggested topics from company internal websites?

    1. I assume you mean, can it be done without additional licensing?  The answer is NO.  PVA in teams give you access to PVA and to Dataverse for Teams without additional licensing.  But the SQL connector used in the flow to access SQL would still be premium and require a premium license for all users.

    2. Yes it will work with company internal websites IF the addresses are reachable from the Internet.  I suspect your internal web site is only accessible on the internal network.  If that is the case it won't work.

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 137,998

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,059

Leaderboard

Featured topics