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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
NoorAlfar
Helper I
Helper I

JSON in dataflow and power query

Hi,

 

Im using this flow to get data from Freshdesk

NoorAlfar_0-1717615500457.png

 

NoorAlfar_2-1717615529175.png

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 
NoorAlfar_3-1717615588848.png

 

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 ?!



1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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

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

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!