Automate the Data extraction from salesforce through Power BI

[Anonymous]

Hi All,

I have to pull the salesforce data on weekly basis and append it to a excel file to use it as backend file for POwer BI. Is there any way to automate it through power BI? So that each week data can be extracted from Sales force and stored in appended form in POwer BI.

Thanks in Advance

[amitchandak]

@Anonymous , check if DAX append can help.

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

else explore power Automate