Forum Discussion
Solved
JSON in dataflow and power query
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 ?!
Save these daily snapshots on a suitable storage system (OneDrive for example) and ingest them as is.
3 Replies
Depends on your archival strategy. Is the file easily re-fetchable from the API or do you need to preserve snapshots?
