Sharepoint List ID in Power BI

[Anonymous]

Hi, I have connected to sharepoint online. 

I'm trying to get the column that contains individual item ids for each list item.

I want this so that in a table in powerbi, I can link a record with its respective URL.

I'm not able to get that after an exhaustive search

Here is an example of my Item ID

https://(namehidden).sharepoint.com/teams/ERPTransformation/Lists/FIT%20Gap%20List%20Final%20Backlog...

I'm looking to extract the entire URL or just the value 2&e=vM6J6

[amitchandak]

@Anonymous , Not able to open link. Not very clear with issue too.

refer if these can help

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

https://www.abelsolutions.com/creating-power-bi-reports-sharepoint-lists/

[Anonymous]

The link cannot be opened because I have changed the URL

I just want the focus to be on the Item ID in URL

[v-zhenbw-msft]

Hi @Anonymous ,

If you want to import just Item ID column, sorry for that the sharepoint connector doesn't support sql statement.

You can only select the tables as below.

And you can do filter in power query. Delete irrelevant columns and keep the Item ID column.

If you have any question, please kindly ask here and we will try to resolve it.

Best regards,

Community Support Team _ zhenbw

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