Need help for converting file paths

Hi Srinivas_BI 

1. Use Power Query to Transform the File Paths:

• You can transform the file paths in Power Query to prepend https:// and convert the backslashes (\) to forward slashes (/).

Steps:

1. Go to Transform Data to open Power Query Editor.
2. Select the column with the file paths.
3. Use the Add Column tab to create a Custom Column with the following formula:
   New Path =  "https://" & Text.Replace([FilePath], "\", "/")
4. This will create a new column with the file paths correctly formatted as URLs.

2. Set the Data Category:

• After transforming the file paths in Power Query and applying the changes, go back to your report view.
• Select the new column name New Path in the Fields pane.
• Go to the Modeling tab and set the Data Category to Web URL.

3.Display the Links in a Table Visual:

• Add the newly created column to your table visual. This should now display clickable URLs that open the PDFs in a browser.

The difference between / and \ in URLs is that / is a valid character used to separate directory paths, while \ is generally not allowed and can cause errors.

/ :

• Purpose: Separates directory paths in URLs.
• Usage: Common and widely accepted in all web browsers and servers.
• Example: https://example.com/folder/subfolder/file.html

\:

• Purpose: Primarily used as a backslash in programming languages.
• Usage: Not commonly used in URLs. If used, it might be interpreted as an escape character or cause errors.
• Example: https://example.com\folder\subfolder\file.html (not recommended)

Thank You