JSON in dataflow and power query

[NoorAlfar]

Hi,

Im using this flow to get data from Freshdesk

where the filename is 

concat('DailyUpdates',formatDateTime(utcNow(),'yyyy-MM-dd-HHmm'),'.json')

I want to open these files in dataflow in the service and use them in a report but i'm getting errors like 

if I open the same folder in power query-desktop, it opens without errors

Is there a workaound for this as I noticed that the transform sample file in service is different than the one on the desktop or can I use the api directly to get the data in the serive ?!

[lbendlin]

Depends on your archival strategy.  Is the file easily re-fetchable from the API or do you need to preserve snapshots?

[NoorAlfar]

I'm pulling data on daily basis only the updated records so I need to save the snapshot.

[lbendlin · Accepted solution]

Save these daily snapshots on a suitable storage system (OneDrive for example) and ingest them as is.