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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How do I save data from a daily emptying data source into another table after a refresh?

So I am using ZappySys's JSON driver to read from a REST API and then pass data to PowerBI through its ODBC service like so

https://api.apiname.com/times?date=CURRENT&order=date 

Now this sends a table once per day in a refresh to PowerBI that contains the work times of that day. The problem is that when I use this as a data source, the previous data from previous dates disappear as they are no longer a part of that dataset.

My question then is how do I transfer this data everyday to a seperate table that I might start a collection of data that contains all of the data from previous days.

2 REPLIES 2
sambarra8
Regular Visitor

did you ever find a solution to this? encountering the same issue

jthomson
Solution Sage
Solution Sage

This sounds less like a desktop question and more of a data preparation before you import it into desktop question

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.