SharePoint shared documents

[Varik]

Hey all,

I'm starting using Power BI and I have a question for you.

I would like to follow the documents I shared with external people (I work as freelance).

I know I can generate a CSV report for each projects but it's not really nice to use.

So I wanted to know if it's possible to create a Power BI dashboard I can use for every projects and yhere I can list the documents I shared with external people.

What I really want is a SP view like the "Shared with us" we can find in every projects. Unfortunately I don't see anything like that with my own documents.

Thank you in advance if you have ideas for me.

[Varik]

Thank you, it's very usefull

[v-luwang-msft · Accepted solution]

Hi @Varik ,

You can use OData feed connector in Power BI desktop then type below URL , choose Documents table:

https://<yoursharepointsite>/_vti_bin/listdata.svc

In Query Editor, you can expand CreatedBy and Modified By columns to see author and editor information. 

refer: https://sharepoint.stackexchange.com/questions/30620/filtering-data-programmatically-on-spview 

Best Regards,

Lucien