Can I work in Desktop Power Query offline when my data source is Web API?

[jrberg]

My data source is Web APIs and I'd like to be able to continue developing my reports and using power query when not connected to the internet.  Currently when the API won't connect I can't do anythign in Power Query.

Is there a way to kind of lock the data down from the previous refresh while I work offline? I wouldnt need to refresh. Currently I just get the warning triangles and edit credentials.

[Eric_Zhang · Accepted solution]

@jrberg

There's no way.

What is the response type of the Web APIs? For JSON and XML, you can save the API response to some JSON or XML file and load the file fromJSON like

Json.Document(File.Contents("C:\Users\xxxxx\Desktop\1.JSON"))

Check more function here.