cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HibaTalat
Regular Visitor

URGENT!! Power BI Report server create trends

Hey Experts,

I am stuck with this thing and it is so hard to figure out

 

So I am using PBIRS, I am so new to PBI in general. 
I have created let's say table A

and want to schedule a weekly refresh for table A after publishing it. 

What do I need in the updated data/Table?

1. Date of the refreshed date in a column 

2. old data and new data (basically I want to save the state of the data)

 

1 ACCEPTED SOLUTION
Shahfaisal
Solution Sage
Solution Sage

It is very easy to schedule data refresh in Power BI Report Server. Please go through - https://learn.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh.

Incremental refresh is not yet avaiable in Power BI Report Server.

It looks like you want to create/store snapshots of data, if that is the case, the best way to do that is in your ETL process and store the data in your database for Power BI to consume. 

 

View solution in original post

1 REPLY 1
Shahfaisal
Solution Sage
Solution Sage

It is very easy to schedule data refresh in Power BI Report Server. Please go through - https://learn.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh.

Incremental refresh is not yet avaiable in Power BI Report Server.

It looks like you want to create/store snapshots of data, if that is the case, the best way to do that is in your ETL process and store the data in your database for Power BI to consume. 

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.