Forum Discussion

RUPSY777's avatar
RUPSY777
Icon for Helper II rankHelper II
6 years ago
Solved

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

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?
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    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.

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
Ephsiba
New Member
2 years ago

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.