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: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
joshua1990
Post Prodigy
Post Prodigy

Export (Direct Query) as Excel or CSV

‎10-10-2021 05:15 AM

Is there any chance to export a direct query table as a csv or excel?

Using DAX or an R/ Python script?

Labels:
Message 1 of 5
4,353 Views
0
1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

‎10-10-2021 05:34 AM

You can use DAX Studio to connect to your model and export as csv or Excel.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Message 2 of 5
4,320 Views
0
4 REPLIES 4
joshua1990
Post Prodigy
Post Prodigy

‎10-10-2021 08:09 AM

Thanks!

And this works also for Direct Query?

Message 4 of 5
4,224 Views
0
mahoneypat
Microsoft Employee
Microsoft Employee
In response to joshua1990

‎10-10-2021 05:46 PM

It does.

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Message 5 of 5
4,182 Views
0
Fowmy
Super User
Super User

‎10-10-2021 05:39 AM

@joshua1990 

Use DAX Studio : https://xxlbi.com/blog/dax-studio-export-all-data/


Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Message 3 of 5
4,295 Views
mahoneypat
Microsoft Employee
Microsoft Employee

‎10-10-2021 05:34 AM

You can use DAX Studio to connect to your model and export as csv or Excel.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Message 2 of 5
4,321 Views
0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

View All
Top Kudoed Authors
View All