PVA - Error on connection when upload excel for suggested topic

[wennie]

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.

[Pstork1 · Accepted solution]

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