# Link data to Power BI

## 🌐 Link data to Power BI web version

For the web version of Power BI we will use the CSV file with respondents data. To do this you need to generate the CSV data file and then to upload it from your device to the online tool.

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MHeso_Q_hiVc608vc_v%2F-MHfK6s8JGAxc57ekyx-%2Fpowerbi1.png?alt=media\&token=a2595e6d-0b81-47e4-b533-258f8cba2158)

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MHfhVnuwCQ-epZTjYeo%2F-MHfhtoWDdLHME5N-qKj%2Fpowerbi9.png?alt=media\&token=9370f879-3875-4942-a81b-0d16c8576cb8)

1. Go to the [**Data export** ](https://docs.ngsurvey.com/form-management/data-export)at the left vertical toolbar
2. Press [**CSV / Excel**](https://docs.ngsurvey.com/form-management/data-export/data-exports/csv-excel) to generate data export for download. 
3. At the web version of the Power BI tool use **Get Data** button 
4. Press **Get** at the **Files** part of the Create new content section to upload the CVS file
5. Upload the file from your device

{% hint style="success" %}
Once the data is generated, it will be automatically downloaded to your device.
{% endhint %}

## 💻 Link data to Power BI desktop version

To link data to the desktop version of the Power BI you can use the [web link](https://docs.ngsurvey.com/form-management/data-export/data-exports/export-jobs) of the data export, which will allow to have an automatic refresh of the data in your report.

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MHfLYrYX286O1Mp2_Ko%2F-MHfcZ6nD0NFDxpOyxfj%2Fpowerbi5.png?alt=media\&token=1a070b65-3d37-4b52-a368-a925d5398726)

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MHfLYrYX286O1Mp2_Ko%2F-MHfbHJ3lzKiQ9LkGBDQ%2Fcaptured%20\(8\).gif?alt=media\&token=771947d3-4df8-41cb-a9ae-530469d164d0)

1. At the Data export page go to the ⚙️**Properties** of the the CSV export results file
2. Enable [Public job result download](https://docs.ngsurvey.com/form-management/data-export/data-exports/export-jobs#export-jobs-properties)
3. Press doubled rectangle near URL to **Copy the link**

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MHfcumLsZweEVzpoo47%2F-MHfe-dFH4wftBrCJ8tj%2Fpowerbi6.png?alt=media\&token=49f1e929-8425-4506-967f-fd4d3f1fc2ac)

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MHfcumLsZweEVzpoo47%2F-MHfe3bVzHvG8vXgncKw%2Fpowerbi7.png?alt=media\&token=ea10c5bf-e497-422b-a584-fe36ff18f807)

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MHfcumLsZweEVzpoo47%2F-MHffd5owVAxMG_gcAoz%2Fpowerbi8.png?alt=media\&token=ee17e135-53e0-4ebd-a235-00b0602f5525)

1. At the Desktop version of Power BI go to the **File** menu and choose **Get data**
2. Select 🌐 Web option
3. Paste the copied link
4. Press **OK** to link the data with Power BI tool