Expert's suggestions import data from stored procedure (live),Appended to the existing week by week

[ssk_1984]

Hi All,

 i am working on weekly report creation, Every week i have show how much as in flow, closed, wip status and camparing with week by week.

data getting from Stored Procedure (SQL), it consuming from live production, so every weeks data wont bee avilable with the existing data, it keeps changing. Every Friday i have to load data into power bi and show current weekly and the existing weeks data as well.

Suggestion here, how to store or create minimum 4 weeks of data in the Power query(separately) , and consume as merging all together... is there any way to incremental refresh for every week friday

[v-hashadapu]

Hi @ssk_1984 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu · Accepted solution]

Hi @ssk_1984 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[Akash_Varuna]

Hi @ssk_1984 To handle weekly Incrimental Data could you try this please 

• Use incremental refresh in Power BI to store 4 weeks of data. Filter the stored procedure with parameters to fetch only the current week's data. Configure the refresh to retain 4 weeks and refresh only the latest week.

• Alternatively, create a historical table in a database or Azure Storage and append weekly data via SQL jobs. Combine this historical table with the current week’s data in Power BI.

• Use Power Query to merge historical and current weekly data.

• Schedule a refresh every Friday in Power BI Service to automate updates.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance