# Get data

In this section, we will get the data by connecting to a database through **DirectQuery mode in Power BI.**

{% hint style="info" %}
If you're looking to create a table from scratch or import spreadsheet data, you can refer to  [this section](/editable/getting-data-into-editable/create-a-table.md).
{% endhint %}

1. To load the required data into Power BI, select **Get data** on the Home tab**.** The procedure is the same as importing any data into Power BI. In this example, we'll choose 'Azure SQL database'.

<figure><img src="/files/GPv1wWnTHHwLal9FayBj" alt=""><figcaption><p>Select database</p></figcaption></figure>

2. In the SQL Server database dialog box, enter the **Server** and **Database (optional)** names, and make sure the **Data Connectivity mode** is set to **DirectQuery**.

<figure><img src="/files/4vUoNwUMXKyArNxpZ5Ul" alt=""><figcaption><p>Enter the server and database names</p></figcaption></figure>

{% hint style="info" %}
EDITable connects to data sources only through **DirectQuery.** This ensures the report always uses the current data.&#x20;
{% endhint %}

**Note:** For any database connection, make sure to select DirectQuery mode. Please find below the image that appears when you select a Snowflake database.

<figure><img src="/files/15iu8EzVDjvPSxf0WXU3" alt="" width="375"><figcaption><p>DirectQuery mode</p></figcaption></figure>

3. Select the required table in the Navigator to preview the data and click **Load.** No transformation is required for this data as it is already prepared.

<figure><img src="/files/4TAjZEH5ZOv2qtkWo6cK" alt="" width="563"><figcaption><p>Load data</p></figcaption></figure>

4. You might get a warning pop-up depending on the connection you choose. Since you will be connecting to your trusted source, you can proceed by clicking **OK** to load the data.

You can now view the 'EmployeeDemo' table in the Data pane. Note that the connection is through DirectQuery.

<figure><img src="/files/TCXnlXFjGDDywCUaPIxO" alt=""><figcaption><p>Data loaded in the Data pane</p></figcaption></figure>

Now that we have connected to the database, the next step is to assign the fields in the Visualizations pane.


---

# Agent Instructions: 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:

```
GET https://docs.inforiver.com/editable/getting-data-into-editable/connect-to-data/get-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.