cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mary168
New Member

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?

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

6 REPLIES 6
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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.

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Mary168
New Member

Hi Pstork,

Got it, thank you very much!

H_Jonaa01
Frequent Visitor

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.

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Virtual Agents News & Announcements

Power Virtual Agents News & Announcements

Keep up to date with current events and community announcements in the Power Virtual Agents community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Virtual Agents Community Blog

Power Virtual Agents Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,742)