Import data from SharePoint URL Link

[yunyun]

Hello, I tried to take SharePoint site URL by Power BI connection. [New data Source]>select[online service]> Select [SharePoiint OnlineList]

However, It seems it doesn't include Site URL which is called ObjectID in Sharepoint audit log data although it includes site Name. 

How can I get the list of SharePoint Site URL ?

Thank you, 

[v-juanli-msft]

Hi @yunyun 

Do you want to get content from a sharepoint list in a subsite of your sharepoint?

If so, please refer to:

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

Or would you like to get all subsite url and write them into Power BI?

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.