Forum Discussion

Jase68's avatar
Jase68
Helper I
6 years ago

Incremental Load from SharePoint list

Hi Power BI Experts, I have a list in SharePoint which has 5 columns and 200 rows.  For 3 of the 5 columns all 200 rows are populated with entries and these entries will never change.  For 2...
Need Help
Jase68's avatar
Jase68
Helper I
6 years ago

Hi Greg,

Thanks for the quick response. 

So if I cannot do this with SharePoint could I replace my SharePoint source with an Excel file and implement this approach?

Jase68's avatar
Jase68
Helper I
6 years ago

To close this off.......

The advice was that I was not able to do this in Power BI \ Sharepoint (given the functionality @ Mar 2020) so I managed to work around this by using Power Automate to grab any data which changed in my SharePoint list and then using the add new row step to push the entire row of data which includes the changed field(s) into a table within an Excel file stored on OneDrive for business and shared within my organisation.  

I then connect Power BI to the table in the shared Excel file to get all the historical data changes as they are made. 

I will need to think about how I manage the size of the Excel table over time but this approach appears to be working for now.