Forum Discussion
Creating a History table with a data flow
I have a JSON web query that pulls back a table of information. (about 2400 rows). This information does not have any date information in it. I'm trying to keep a running history of what this data...
No. Use Power Automate to pull your JSON daily, slap the timestamp on, and save the data somewhere as a CSV file on a Onedrive or something. Then point Power BI to that OneDrive folder and consume the CSV files.
For a ore modern experience, ignore the CSV part and save the JSON as is - Power BI can read that just fine, and you can use the filedate as the timestamp.
You could even do incremental refresh but that's overkill with just 2400 rows per day.