how can i export data from POWER BI query editor to excel or csv or sharepoint automatically ?

[RUPSY777]

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?

[Miltos]

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]

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.

[edhans]

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.

[ImkeF]

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?

[Rubayat]

you are awsome! This solution works for me. 

[RUPSY777]

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

[ImkeF · Accepted solution]

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.

[Ephsiba]

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.