cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

PVA - Error on connection when upload excel for suggested topic

Hi all,

I had formatted my excel to 2 columns, question and answer in pair. 

The excel is stored in a team channel. I had checked the link and is correctly link me to the file with URL I included.

However PVA return Error on connection issues when I upload the file.

Any idea?

 

Connection issues
We couldn’t connect to this link, or it’s not secure. Make sure it’s secure (beginning with https://) and that it’s a working link.
 
1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

The problem is that the file is stored in a team channel.  That means its in a SharePoint site that requires authentication to access the file.  When you try to access it normally that authentication takes place in the background and you don't notice.  But the documentation specifies that for Suggested topics the file must be publicly available.  Since its in SharePoint (Team Channel) its not.  Take a look at the Important! box on this list of prerequisites.

Get topic suggestions from online content - Power Virtual Agents | Microsoft Docs



-------------------------------------------------------------------------
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

2 REPLIES 2
Pstork1
Dual Super User
Dual Super User

The problem is that the file is stored in a team channel.  That means its in a SharePoint site that requires authentication to access the file.  When you try to access it normally that authentication takes place in the background and you don't notice.  But the documentation specifies that for Suggested topics the file must be publicly available.  Since its in SharePoint (Team Channel) its not.  Take a look at the Important! box on this list of prerequisites.

Get topic suggestions from online content - Power Virtual Agents | Microsoft Docs



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

Hi,

I'm facing the same issue. Thank you for that sharp answer. I want to import a large range of data in the bot.  Creating the topics directly in the bot will take too much time. Looking for a  fallback. The data must  remain private.

 

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 (5,026)