Download/Export file from Power Query

[Anonymous]

Hi,

I am trying to download/export this JSON file directly from Power Query. Any help appreciated. Thank you.

let
Source = (Web.Contents("https://support.oneskyapp.com/hc/en-us/article_attachments/202761627/example_1.json"))
in
Source

[negi007 · Accepted solution]

@Anonymous 

Please follow below steps. connect to your json data source

then you will get below screen. click onthe into table icon on the right top corner

below is your data.

on refresh you json will get updated data. let me know if you still need help. thanks

[Anonymous]

Hi @negi007 ,

Thanks for your reply. I need to download it as a JSON file from the Power Query editor. I don't want to open the JSON file in the Power Query editor. I found some help from the biccountant site but couldn't achieve my needed result 😞
https://www.thebiccountant.com/?s=export+data+from+Power+BI&submit=Search

[themistoklis]

@Anonymous 

I dont think you can export the table into csv or other file format throug Power Query

As a workaround you can click on the top left icon of the table in Power Query Editor, and then click on 'Copy Entire Table'.

Then open an excel spreadsheet and paste the data there. With this workaround you can only copy the first 1000 rows.

If you want to copy all rows you need to load the data first, then go to Desktop and on 'Data' section select the table. Then do right click any where in the table and select copy table. This way you will copy all rows from the table

[Anonymous]

Hi @themistoklis,

Thanks for your help. Hopefully, someday we will be able to export the entire file through Power Query 🙂