Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Download/Export file from Power Query

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_a...
Need Help
  • negi007's avatar
    negi007
    5 years ago

    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

themistoklis's avatar
themistoklis
Community Champion
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi themistoklis,

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