URL within PBI that links to SharePoint list item

[Anonymous]

I have a query to a SharePoint list.  It yields many list columns including one called "ItemLink".  In a visualization table I have added "ItemLink".  In each line of the table it displays the same thing http://xxx.xxx.net/projects/Lists/xxx%20xxxx/dispform.aspx?ID=.

If I could combine that link with the the actual SharePoint list ID I would have a link within the vizualization back to the list item in SharePoint.   For instance, if I had a list ID of 45 and added it to the link I would have the link http://xxx.xxx.net/projects/Lists/xxx%20xxxx/dispform.aspx?ID=45.  This link would take me to that specific list item.

However, the content of the ID column in the query is always the number 1 as opposed to the specific ID number like 45 that I used in the above example.  

Can anyone say why I get 1 rather than the actual list ID?

Or, is there a better way to have a link within a PBI visual to go back to a SharePoint list item?

Thanks in advance

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Anonymous]

FYI; To the administrators who send me emails suggesting I mark this solved.  It's not. Thanks

[v-luwang-msft]

Hi @Anonymous ,

You can use URL filter, please refer to: https://docs.microsoft.com/en-us/power-bi/service-url-filters.

Regards,

Lucien 

[Anonymous]

Lucien, Thank you for your reply.  I'm trying to include a link within the PBI vizualization which is a link back to SharePoint which is the source of the vizualization.