Status Updates on Sharepoint List

Question

Hi,&nbsp;I have a sharpoint list that I am using to hold projects that we are working on.&nbsp;We have a pipeline where projects change status over time. My job is to compile a report using Power BI that details the exact date that these projects change status e.g. during the last quarter x amount of projects changed status from y to z.&nbsp;The status field is lookup column within a normal Sharepoint list.&nbsp;How can I go about creating this report within Power BI?&nbsp;Any help would be greatly appreciated.Thanks.

v-lili6-msft · Answer

hi, Jibber_Jabber
For your data source is sharepoint list, you could get data from sharepoint list and then configure refresh, then
the dateset will refersh automatically.
Here are some official documents for your reference:
https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data-from-sharepoint-list-library.aspx
https://docs.microsoft.com/en-us/power-bi/refresh-data
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
&nbsp;
Best Regards,
Lin

Forum Discussion

Status Updates on Sharepoint List

1 Reply

Related content

Map/Selecting Bubbles, Updating SharePoint from Button

Sharepoint file not updated

Sharepoint folder excel live update

Sharepoint list mirroring

App not updating