Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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?
Solved! Go to 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.
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
I close and apply the query and then put it as visualization table. Then I can export it as csv from the table
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @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
you are awsome! This solution works for me.
can you elaborate more as i am very new to power bi and can this be automated?
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |