Forum Discussion
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_attachments/202761627/example_1.json"))
in
Source
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
4 Replies
Anonymous
I dont think you can export the table into csv or other file format throug Power QueryAs 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
Hi themistoklis,
Thanks for your help. Hopefully, someday we will be able to export the entire file through Power Query 🙂
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
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
