Solved: Re: how can i export data from POWER BI query edit...

RUPSY777 · ‎04-14-2020

how can i export data from POWER BI query editor to excel or csv or sharepoint automatically without copy table or export table fro visual option. I dont have DAX nor R installed so please help?

ImkeF · ‎04-15-2020

Hi @RUPSY777

not sure I understand with automated.

What I meant was that you can run the same queries that you run in Power BI in Excel instead.

Then when you open the Excel file and refresh the data, you see the new data.

You could also set to refresh automatically when opening the file.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

Miltos · ‎04-18-2023

I close and apply the query and then put it as visualization table. Then I can export it as csv from the table

Greg_Deckler · ‎04-14-2020

Power Query is for data ingest, it really isn't setup for the creation of files. I really think you would need R or Python to do that but @ImkeF or @edhans might know better.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

edhans · ‎04-14-2020

Yeah. Not really aware of a good way. I sometimes will use DAX Studio to export loaded tables to text files.

You could use the Power Query connector in Power Automate then use an export to file in a flow. You can write your Power Query code in Power BI desktop or Excel, then just copy the M code to Power Automate, assuming it has access to the files or data, either via cloud (SharePoint online) or the on prem Gateway.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

ImkeF · ‎04-14-2020

Hi @RUPSY777 ,

as you're so specific about exporting tables from the query editor: Why not copying the queries to Power Query in Excel, load the data to the sheet there and refresh that workbook?

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Rubayat · ‎01-19-2023

you are awsome! This solution works for me.

RUPSY777 · ‎04-15-2020

can you elaborate more as i am very new to power bi and can this be automated?

ImkeF · ‎04-15-2020

Hi @RUPSY777

not sure I understand with automated.

What I meant was that you can run the same queries that you run in Power BI in Excel instead.

Then when you open the Excel file and refresh the data, you see the new data.

You could also set to refresh automatically when opening the file.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Ephsiba · ‎02-05-2024

This works for me. I opened a new excel sheet and opened query editor. In power bi i opened the query editor of the required file and right clicked the table i want and selected advanced editor and copied the entire data and pasted it in the advanced editor of the excel query editor. then save and load.