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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Retain old data in report server

I am using Power BI Report Server. I am pulling table load details from bigquery and getting the last loaded date and row count. The problem is when I am refreshing the query the next day, I am only getting the details for the current date and previous date data will be gone since I am pulling last modified date. Is there anyway I can store the old data so that I can have the row count for all the dates. Incremental refresh is not enabled in report server

 

Thanks in advance

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

You may consider storing the data into a database and then load them into Power BI.