> For the complete documentation index, see [llms.txt](https://documentation.astera.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://documentation.astera.com/astera-data-stack-v8/report-model/exporting-options/exporting-report-model-to-a-dataflow.md).

# Exporting Report Model to a Dataflow

In Astera, you can export the extracted data to various destinations such as Excel workbooks and files, or a database table destination such as SQL Server, PostgreSQL, MySQL, ODBC, etc.

{% hint style="info" %}
**Note:** The data providers available to you depend upon the Astera license you have purchased.
{% endhint %}

![](/files/1tOsoshDj1mDSPMwPDBI)

![](/files/q1snFjBSUHKan7lZ3Jru)

Follow the steps mentioned below to export your Report Model to a dataflow:

1. Click on the icon in the *Model Layout* panel if you want to export your data to an Excel destination. This will open a new window where you will have to specify the output file location.

![](/files/vpcXJTP4MCEvjXkmnBUv)

While exporting in Astera, you have the option to send only filtered data to your export destination. You can see the ![](/files/aevs5JqCLetB8mow6il7)sign in the data export properties window where you can apply different filters to your data to get your desired output. Click on it to expand the available options.

![](/files/KKsXrNZgU7fKwtmU8Dbp)

When you expand the rules for filtering data, you will see the following three sections:

* *Functions -* an extensive library of built-in functions from where you can select any function according to your requirement and apply it to your data
* *Objects Panel -* it contains the layout of your report model from where you can simply double-click on the object and write it in your function
* *Expression builder -* here you can write your expressions by either selecting it from the built-in functions library or writing one of your own

2. Write the expression *ITEM= “SOFA”* in the expression builder. Compile your expression to check if it is successful and click OK when the compile status is successful.

![](/files/FvLg6Rcd1GEkA4HldxP1)

3. Go to the *Model Layout* panel where you can see your exported file with multiple export setting options such as:
   * *Preview Selected Export*
   * *Edit Export Settings*
   * *Run Selected Export*
   * *Create Dataflow*
   * *Open and Remove Export Settings*

![](/files/I3ig4LwHD6HRisQwaFP4)

4. Click on the *Run Selected Export* button. While the export is running, you can see the progress details and completion status in the job trace appearing in the *Job Progress* window. On a successful job run, you will get a clickable link to the destination file and the log file in the job trace. If your export encountered any errors during the run, you can click on the link for the log file and view the error details.

![](/files/PYx1t7d3oRIvcZ5GGbkI)

5. Click on the destination file link to open the output file. You can see that only filtered items have been exported to the destination file.

![](/files/PtVGM6mSW4UqaOO9bzXS)

6. Now, to export your Report Model to a dataflow, click on *Create Dataflow and the Open* ![](/files/ha1zv4UWz4KNGpB5qqcG)option present in the *Data Export Settings* panel.

![](/files/aX3rAltyJvMBRqA966Ao)

This is how your dataflow would look like:

![](/files/7C5YwUNR25SOqcf4fj7F)

Your dataflow will successfully be created.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://documentation.astera.com/astera-data-stack-v8/report-model/exporting-options/exporting-report-model-to-a-dataflow.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.