Hello,
I’m building a Quicksight dashboard, and I need to include links to files in my team’s Workdocs folders. I’ve created a table in Quicksight that includes the clickable URLs. I’m not having any trouble with the URLs that lead to FOLDERS in Workdocs, but when I link directly to a FILE in Workdocs, I receive the error message in the attached screenshot.
My data source is an Excel file. I can’t use S3 or Redshift at the moment.
Is there any way I can make these file links work?
@prestonb ,
If the error message is after clicking the Workdocs URL link from QuickSight which opens a new , then from the screenshot, I understand the user does not have access to link. Possibly sorting out access issue should help in viewing the file.
Kind regards,
Koushik
@Koushik_Muthanna thanks for getting back to me!
I definitely have access to the linked file: I’m able to access it via Workdocs, but when I follow the URL from Quicksight I receive the error. It seems something in Quicksight is producing the problem. Do you have any idea how I could resolve this?
@prestonb ,
Do you have a few different file types which are to be accessed ? ( image , pdf , excel ) . I was able to test a Workdocs url from QuickSight which is a powerpoint file.
1/Copy the Workdocs link file and test in the browser
2/Create a calculated field and add the link to create a string value.
3/Use that in the table , enable field styling to show as hyperlink [ Make URLs hyperlinks ]
4/Test if that works for different file types
@Koushik_Muthanna ,
Could you please explain the second step further? I already have the links in Quicksight because I’ve entered them into the dataset, and I’ve already converted them to clickable hyperlinks. Is a calculated field necessary? If yes, could you please help me understand what the calculated field should do?
If yes, could you please help me understand what the calculated field should do?
This was for you to test different links and if you did not have them in your dataset, you could just copy paste a link in a calculated field and then test if the hyperlink would work when clicked from a table.
Validate if the links that are opened in the browser vs the actual links are the same without for example any special characters.
@Koushik_Muthanna ,
Thank you for your help - I’ve identified the problem. For some reason, Workdocs links pasted into Excel don’t paste correctly. I guess I’ll keep trying to get to the bottom of this.