File path changing in Report view

[DBC01]

Hi all,

I was wondering anyone had expiereineced something similiar. I have a SQL script that is pulling through the filepath of images stored locally. My intention is to create a new column and concatenate this filepath with "file:" in order to create a Web URL, allowing the end user to click on the link and open the photo. However, whilst the the filepaths are coming through without issue in the table view, when they are displayed in Report view the filepath has changed, breaking the link. 

I have had to redact parts of the filepath, however, below you can see the filepath includes 'Dec 21 - Mar 24', which is correct.

However, when displayed in Report view, "Mar 24" changes to an ever increasing number, in the base below both "Mar 100" and "Mar 1000" are shown.

Does anyone know how to prevent this from happening? 

Thanks in advance 🙂

[Anonymous]

Hi @DBC01 

Can you check if the Record_No in your visual for these paths corresponds to the No in your table? You can then refresh the table, and if that doesn't work, try to remove the data permissions in data source settings.

reconnect to the database, and load the data into the visual to see if it's correct.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DBC01]

Thank you @Anonymous, I can confirm that the Record_no does not match the number displayed in the table; the filepath should always read "Dec 21 - Mar 24". I have  also cleared permissions and re-imported the data but unfortunately there has been no change. Thank you again.