
[ad_1]

Replace 2021 March:
Now you can export the info direct from Energy BI Desktop utilizing my device, Energy BI Exporter. Learn extra right here.
Replace 2019 April:
For those who’re fascinated about exporting the info mannequin from both Energy BI Desktop or Energy BI Service to CSV or SQL Server examine this out. The strategy defined right here is barely relevant for Energy BI Premium or Embedded capacities with XMLA endpoints connectivity.
One of many options that’s requested lots on Energy BI group is find out how to export Energy BI desktop knowledge to Excel OR CSV.
Observe: I’d prefer to make it clear that on this article we’re NOT fascinated about exporting knowledge from a visible in a report back to CSV.
The primary query numerous you may need is “How on earth somebody needs to export knowledge from a Energy BI Desktop mannequin to Excel OR CSV?”.
Energy BI brings Energy Question, Energy Pivot, Energy View and Energy Map collectively in a single piece of software program. So why not utilizing Excel on the first place to load knowledge from the supply? There could be numerous different questions concerning the causes that somebody needs to export knowledge from Energy BI Desktop mannequin to Excel (or some other locations). The explanation could possibly be one of many following that somebody needs to export knowledge from Energy BI Desktop mannequin to different locations like Excel, CSV, SQL Server and many others.
- For some cause you could have only a Energy BI Desktop file (PBIX) and also you don’t have entry to the info sources and it’s essential to present the info to somebody who shouldn’t be acquainted with Energy BI
- You Energy BI Desktop consolidates numerous totally different sources in a single mannequin and it could be very exhausting to get the identical output as you get in Energy BI Desktop mannequin in Excel. So an export function will be tremendous helpful
- You may need executed numerous advanced transformations in Energy BI Question Editor and replication the identical logic on the supply system could possibly be far more advanced and time consuming, so once more exporting knowledge from a present Energy BI Desktop mannequin is sensible
- You’ve gotten a bunch of calculated columns created in DAX and also you don’t wish to return and redo all of the exhausting works you could have already executed in Energy BI in one other setting like Excel
- You may wish to use the present Energy BI knowledge in Cortana Analytics
- You’re simply curious to see whether it is potential
- Not one of the above!
However, the truth is that whatever the cause, numerous folks nonetheless wish to export knowledge from Energy BI Desktop to totally different locations. So let’s take a look at totally different workarounds till this function shouldn’t be accessible in Energy BI. I’ll clarify alternative ways to export Energy BI Desktop knowledge in a sequence of articles. On this submit you learn to copy Energy BI Desktop knowledge to a vacation spot file like Excel or CSV with none third-party software program concerned. I additionally clarify how simple you may export Energy BI Desktop knowledge to CSV utilizing DAX Studio.
The simplest workaround is solely copy/paste knowledge from Information view in Energy BI Desktop.
- Open your Energy BI Desktop mannequin
- Change to Information view by clicking on Information tab

You’ve gotten now 3 choices to repeat knowledge:
- Proper click on on a desired desk and click on “Copy Desk”

- Click on a desired desk then from the ribbon, click on “Copy”

- Click on a desired desk, proper click on on knowledge space then click on “Copy Desk”

- Now open a brand new Excel file and paste the copied knowledge

Execs:
- You may copy the complete desk, together with all DAX calculated columns, very simply and paste it on a vacation spot like Excel or a textual content editor and put it aside as TXT or CSV recordsdata
- You copy reworked and doubtless cleansed knowledge in case you could have executed any knowledge transformation in Question Editor
- No third get together device is required/concerned
Cons:
- If for any cause you wish to paste the info in SQL Server, this may not be the easiest way to get the job executed
- This manner is nice for small quantity of knowledge. If you wish to copy a bigger quantity of knowledge than some hundreds rows, say even 64,000 rows, then the copy course of may take a very long time
- There may be at all times a danger of lacking knowledge as we’re copying knowledge into Home windows clipboard
One other simple workaround is to repeat knowledge from Question editor:
- On Energy BI Desktop click on “Edit Queries” to open Question Editor
- Choose a desired question
Now you could have 2 choices:
- Click on on the tiny desk button situated on the highest left of the desk and click on “Copy Complete Desk”

- Press Ctrl+A to pick out all columns, then press Ctrl+C to repeat knowledge or proper click on on a column header and click on “Copy”. You may choose a number of columns by urgent Ctrl and clicking on column headers in case you don’t wish to copy the complete desk.

You may as well choose totally different ranges of knowledge transformation to be copied.

- Now you may paste the info to Excel
Execs:
- You may copy the complete desk, very simply and paste it on a vacation spot like Excel or a textual content editor and put it aside as TXT or CSV recordsdata
- You may copy a number of chosen columns relatively than copying the complete desk
- Not solely are you able to copy reworked knowledge in case you could have executed any knowledge transformation in Question Editor, but in addition you may determine which degree of reworked knowledge needs to be copied
- No third get together device is required/concerned
Cons:
- DAX calculated columns are NOT included
- For those who use Ctrl+A, you choose all columns to be copied which incorporates advanced columns robotically added to the desk. For a desk like DimDate which doubtlessly has numerous relationships with different tables, you most likely don’t prefer it.

- It’s not that simple to export knowledge in different locations like SQL Server
- Poor efficiency in copying great amount of knowledge
- Threat of lacking knowledge as we’re copying knowledge into Home windows clipboard
Export Information from Energy BI Desktop to CSV or TXT Utilizing DAX Studio
Replace: For those who’d prefer to export the mannequin knowledge as an entire, examine this out.
Exporting knowledge from Energy BI Desktop to CSV utilizing DAX Studio is tremendous simple. A bonus of utilizing DAX Studio is that it really works nice whatever the quantity of knowledge you wish to export. The opposite benefit is which you could actually export a question output to CSV which will be very useful in case you don’t wish to solely export the complete desk, however a selected question.
Right here is find out how to get the job executed in DAX Studio:
- Open a desired Energy BI Desktop mannequin
- Open DAX Studio
- Click on “PBI / SSDT Mannequin” then choose your Energy BI mannequin from the listing then click on “Join”

- Write a desired DAX question, I’m not going to clarify DAX question language on this article, however you may merely write “EVALUATE TABLE_NAME” which “TABLE_NAME” is the title of the desk you wish to export. So in our case it’s “FactInternetSales”

- Run, or press F5, to execute the question
- Click on “Outcomes” tab and be sure to get the anticipated outcomes

- Click on “Output” from the ribbon and choose “File”

- Run the question
- Choose a folder and enter file title to save lots of the ends in TXT or CSV then click on “Save”

- Now DAX Studio begin writing knowledge into the output file

- After DAX Studio completed writing knowledge it’s possible you’ll open the file

Backside line: You may simply copy/paste your Energy BI Desktop knowledge to a vacation spot like Excel or notepad from Energy BI Desktop as defined above. You may as well export Energy BI knowledge utilizing DAX Studio to CSV very simply. Nonetheless, the primary method it’s helpful solely once you wish to copy small quantity of knowledge. DAX Studio is tremendous simple and really highly effective device to export knowledge from Energy BI Desktop to CSV or TXT recordsdata. However, what if it’s essential to load extra knowledge to Excel and even SQL Server?
In my subsequent submit I’ll clarify find out how to straight import Energy BI Desktop knowledge to Excel, so keep tuned.
Associated
[ad_2]