> For the complete documentation index, see [llms.txt](https://docs.humdata.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.humdata.org/build/hdx-apis/file-download-endpoint/tools.md).

# Tools

Learn how to use the file download in Power BI.

The File download is suitable for complete file based ingestion and scheduled refreshes where the underlying file is updated over time. Due to performance issues, resources downloaded through the File download should be small (see Tabular Data Endpoints section for ability to query large datasets).

## Power BI

HDX file URL resources can be used directly as a data source in Power BI and other Microsoft tools that support Power Query, such as Fabric. Follow this section to connect HDX’s File URL endpoint to Power BI as a data source.

{% stepper %}
{% step %}

#### **Open Power BI Desktop. From the Home menu, select Get data, then choose Web as the data source.**

<div align="left" data-with-frame="true"><figure><img src="https://1756329736-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FPYX6VfEjVd6ssH4AU60M%2Fuploads%2F6CyDsE8AGfYmfO9vRFQ0%2Funknown.png?alt=media&amp;token=08f85bbb-0985-4a20-9148-3025e54da9a2" alt="" width="563"><figcaption><p>Web</p></figcaption></figure></div>

{% endstep %}

{% step %}

#### In the URL field, paste the  `download_url`  for the resource you want to load.

<div align="left" data-with-frame="true"><figure><img src="https://1756329736-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FPYX6VfEjVd6ssH4AU60M%2Fuploads%2Fp5Iw2sWoA8qF0PyLbzA9%2Funknown.png?alt=media&amp;token=1c9bf6f8-851e-455b-a3f1-9c924f58800a" alt="" width="563"><figcaption><p>URL field</p></figcaption></figure></div>

{% endstep %}

{% step %}

#### **If prompted for credentials, select Anonymous. If you encounter credential errors, go to File → Options and settings → Data source settings, clear existing permissions for the URL, and retry the connection.**

{% endstep %}

{% step %}

### **Once the data preview loads in the Power Query Editor, click Close & Apply to load the dataset into Power BI. Power BI will re-download the file on refresh using the same URL.**

<div align="left" data-with-frame="true"><figure><img src="https://1756329736-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FPYX6VfEjVd6ssH4AU60M%2Fuploads%2F8NpJ1DkexeWo8BU7uG0I%2Funknown.png?alt=media&amp;token=405a1a51-ef39-493e-ac1f-084235d60665" alt="" width="563"><figcaption><p>Load</p></figcaption></figure></div>
{% endstep %}
{% endstepper %}

For datasets with multiple resources or changing file structures, ensure the selected `download_url` consistently points to the intended file.


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.humdata.org/build/hdx-apis/file-download-endpoint/tools.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.