azure blob_如何使用Power BI从Azure Blob存储访问数据

azure blob

In this article, I am going to explain how we can access the data from the Azure Blob Storage using Power BI. To do that, we are going to use the below tools:

在本文中，我将解释如何使用Power BI从Azure Blob存储访问数据。 为此，我们将使用以下工具：

1. Azure BLOB Storage account: We have uploaded the source CSV file to it
2. Azure BLOB存储帐户 ：我们已将源CSV文件上传到该帐户
3. Power Query editor: To choose the data that we want to load in the Power BI report Power Query编辑器：选择我们要在Power BI报表中加载的数据
4. Power BI Desktop: To view the data imported from the CSV file Power BI Desktop：查看从CSV文件导入的数据

演示设置 (Demo Setup )

To demonstrate the process, I have created a Blob Storage account on Azure named “myfirstblobstorage”:

为了演示该过程，我在Azure上创建了一个名为“ myfirstblobstorage ”的Blob存储帐户：

I have also created a container named “excelfiles” in the Azure Blob Storage account. I have uploaded a CSV (comma separated values) file named “Countryregion.csv” on the Blob Storage container. To know the process of uploading the file on Azure Blob Container, read this article.

我还在Azure Blob存储帐户中创建了一个名为“ excelfiles ”的容器。 我已经在Blob存储容器中上传了一个名为“ Countryregion.csv ”的CSV（逗号分隔值）文件。 要知道上传到Azure上的Blob容器中的文件的过程中，阅读此文章。

The CSV file contains the list of countries, their country codes, and create date of the record. We are going to use access keys to authenticate to the blob storage account. You can read more about accessing the blob data using the Azure portal from this article.

CSV文件包含国家 / 地区 列表，国家 / 地区代码以及记录的创建日期 。 我们将使用访问密钥对Blob存储帐户进行身份验证。 您可以从