Solved: Re: Export (Direct Query) as Excel or CSV

joshua1990 · ‎10-10-2021

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

Using DAX or an R/ Python script?

mahoneypat · ‎10-10-2021

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

joshua1990 · ‎10-10-2021

Thanks!

And this works also for Direct Query?

mahoneypat · ‎10-10-2021

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

Fowmy · ‎10-10-2021

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

mahoneypat · ‎10-10-2021

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

Export (Direct Query) as Excel or CSV