SOLVED

URL for a list item into Power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-1020333%22%20slang%3D%22en-US%22%3EURL%20for%20a%20list%20item%20into%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1020333%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20a%20SP%20developer%20but%20this%20is%20a%20question%20that%20perhaps%20a%20developer%20would%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20bring%20data%20from%20sharepoint%20list%20into%20power%20BI.%26nbsp%3B%20I%20am%20confronted%20by%20the%20various%20navigation%20steps%2C%20but%20eventually%20can%20create%20a%20dataset%20of%20the%20list%20items.%26nbsp%3B%20However%2C%20I%20can't%20seem%20to%20isolate%20a%20field%20which%20gives%20me%20URL%20of%20each%20item.%26nbsp%3B%20I%20can%20create%20one%20by%20spoofing%20the%20url%20of%20the%20list%20address%20and%20then%20adding%20the%20item%20suffix%20(everything%20below%20in%20bold)%20plus%20in%20this%20case%20the%20number%203.....I%20worry%20whether%20this%20is%20foolproof%20though%20because%20when%20I%20then%20visualise%20that%20in%20Power%20BI%20table%20and%20follow%20the%20link%20then%20sometimes%20it%20seems%20to%20break.%20%26nbsp%3B%20What%20does%20the%20last%20piece%20of%20the%20suffix%20represent%26nbsp%3B%20(in%20italics)%2C%20is%20it%20essential%2C%20and%20can%20it%20be%20sourced%20from%20the%20metadata%20that%20is%20presented%20to%20Power%20BI%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fxxxxxxxxxxxxxx.com%2Fsites%2FDemo%2FLists%2FDemoList%2FDispForm.aspx%3FID%3D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fxxxxxxxxxxxxxx.com%2Fsites%2FDemo%2FLists%2FDemoList%2FDispForm.aspx%3FID%3D%3C%2FA%3E%3C%2FSTRONG%3E3%3CEM%3E%26amp%3Be%3DMYJpGX%3C%2FEM%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EThanks%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1020333%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPIs%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1028727%22%20slang%3D%22en-US%22%3ERe%3A%20URL%20for%20a%20list%20item%20into%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1028727%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F463186%22%20target%3D%22_blank%22%3E%40ghdunn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20don't%20need%20the%20italis%20url%20part%2C%20and%20you%20can%20use%20ID%20field%20value%20in%20order%20to%20build%20a%20list%20item%20direct%20url.%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EFederico%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1029169%22%20slang%3D%22en-US%22%3ERe%3A%20URL%20for%20a%20list%20item%20into%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1029169%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F138334%22%20target%3D%22_blank%22%3E%40Federico%20Porceddu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Federico...I%20will%20use%20that%20approach.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOut%20of%20interest%2C%20do%20you%20know%20why%20there%20isn't%20a%20full%20URL%20exposed%20for%20each%20list%20item%3F%26nbsp%3B%20It%20must%20exist%20somewhere%20in%20the%20metadata%2C%20because%20when%20you%20share%20an%20item%20you%20can%20'copy%20link'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGerald%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1030605%22%20slang%3D%22en-US%22%3ERe%3A%20URL%20for%20a%20list%20item%20into%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030605%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F463186%22%20target%3D%22_blank%22%3E%40ghdunn%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fshare-a-list-item-in-sharepoint-c270ccaf-89a2-4f7e-874a-5da98824d449%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Esharing%20Links%3C%2FA%3E%20%3CSPAN%3Ehave%20a%20different%20meaning.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESharing%20Links%20also%20carry%20sharing%20permissions%20information%20for%20one%20or%20more%20users%2C%20so%20it%20is%20possible%20through%20a%20link%20(the%20same%20that%20is%20taken%20from%20the%20interface)%20to%20give%20access%20from%20the%20point%20of%20view%20of%20security%20to%20specific%20users.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EUrl%20with%20the%20ID%20assumes%20that%20the%20user%20has%20already%20access%2C%20so%20there%20is%20not%20sharing%20(permissions)%20needs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EFederico%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

 

I am not a SP developer but this is a question that perhaps a developer would know.

 

I am trying to bring data from sharepoint list into power BI.  I am confronted by the various navigation steps, but eventually can create a dataset of the list items.  However, I can't seem to isolate a field which gives me URL of each item.  I can create one by spoofing the url of the list address and then adding the item suffix (everything below in bold) plus in this case the number 3.....I worry whether this is foolproof though because when I then visualise that in Power BI table and follow the link then sometimes it seems to break.   What does the last piece of the suffix represent  (in italics), is it essential, and can it be sourced from the metadata that is presented to Power BI?

 

https://xxxxxxxxxxxxxx.com/sites/Demo/Lists/DemoList/DispForm.aspx?ID=3&e=MYJpGX

 

Thanks

3 Replies
best response confirmed by ghdunn (Contributor)
Solution

Hi @ghdunn 

you don't need the italis url part, and you can use ID field value in order to build a list item direct url.

Cheers,

Federico

@Federico Porceddu 

 

Thanks Federico...I will use that approach.

 

Out of interest, do you know why there isn't a full URL exposed for each list item?  It must exist somewhere in the metadata, because when you share an item you can 'copy link'.

 

Gerald

Hi @ghdunn ,

sharing Links have a different meaning.

Sharing Links also carry sharing permissions information for one or more users, so it is possible through a link (the same that is taken from the interface) to give access from the point of view of security to specific users. 

Url with the ID assumes that the user has already access, so there is not sharing (permissions) needs.

 

Cheers,

Federico