Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors