2 Ways To Export Your Filtered Data From Power BI To A CSV File
There are 2 ways to export data from Power BI to a CSV file, an easy one and a professional one.
- The easy method:
The easy one is to export the data with the option that is already available within Power BI
Pros:
- Easy to do
- You can apply your filters and choose your columns
Cons:
- When exporting large data it will just export a sample and it gives you a warning of this before writing the file
 |
| First You will have to check this if it's not checked |
 |
| Then you can easily export it to CSV, after applying all filters you want like this |
2. The Pro method:
Using Dax Studio you can easily export any volume of data with any desirable format
Pros:
- Very Effective
Cons:
- You will need to know how to write Dax or you can do your search
You Will Obviously Have To Download Dax Studio
It is a free 8MBs tool that can be easily downloaded from here: DAX Studio - The ultimate client tool for working with DAX queries
 |
| From External tools open Dax Studio |
 |
| Choose your output as a file |
 |
| Write your query and hit Run. Here for example I wanted only the data in the table1 within a certain time range you can apply any filter you want just like this |
Now you can export data from Power BI to a CSV file like whatever you want.
Regards.
👏👏
ReplyDelete