Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
RUPSY777
Helper II
Helper II

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

‎04-14-2020 06:18 AM

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?

Labels:
Message 1 of 9
76,489 Views
0
1 ACCEPTED SOLUTION
ImkeF
Super User
Super User
In response to RUPSY777

‎04-15-2020 02:08 AM

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

Message 6 of 9
76,426 Views
8 REPLIES 8
Miltos
New Member

‎04-18-2023 11:24 PM

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

Message 9 of 9
54,739 Views
Greg_Deckler
Super User
Super User

‎04-14-2020 06:43 AM
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!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 9
76,479 Views
0
edhans
Super User
Super User
In response to Greg_Deckler

‎04-14-2020 09:09 AM

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
Message 3 of 9
76,460 Views
ImkeF
Super User
Super User
In response to edhans

‎04-14-2020 10:56 AM

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

Message 4 of 9
76,452 Views
Rubayat
Regular Visitor
In response to ImkeF

‎01-19-2023 09:21 PM

you are awsome! This solution works for me. 

Message 8 of 9
59,215 Views
RUPSY777
Helper II
Helper II
In response to ImkeF

‎04-15-2020 01:36 AM

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

Message 5 of 9
76,429 Views
0
ImkeF
Super User
Super User
In response to RUPSY777

‎04-15-2020 02:08 AM

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

Message 6 of 9
76,427 Views
Ephsiba
New Member
In response to ImkeF

‎02-05-2024 11:42 PM

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.

Message 7 of 9
35,373 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

View All