Retrieving data
Retrieving is the process of fetching data from a location. Power BI has connectors to various data sources, ranging from text and comma-separated values (CSV) files to databases and web pages. Some common Power BI connectors are shown in the following screenshot:
Figure 11.1: List of common Power BI connectors
In this section, we will learn how to retrieve data from a CSV file.
Getting ready
Download the Products_bikes.csv file from the Chapter 11 folder in the GitHub repository of this book: https://packt.link/Power-BI-samples.
You don’t need any special permission to retrieve data from files such as text, CSV, or Excel files.
If you are querying a secure data store, you might require additional permissions.
How to do it…
- Open the Power BI Desktop tool.
- Click on Get Data and select the Text/CSV option:
Figure 11.2: Connecting to a data source
- Press Connect. ...
