Azure Data Lake Storage Gen1
Power Query is a powerful and versatile tool that is used to extract, transform and load data from various sources. One of the sources that Power Query can connect to is the Azure Data Lake Storage Gen1. In this article, we will explore the Power Query M Language code that is used to connect to the Azure Data Lake Storage Gen1 data source from inside Power BI.
What is Power Query M Language?
Power Query M Language is a functional language that is used to define queries in Power Query. It is a language that is used to transform and shape data in Power Query. The language is designed to be easy to read and write, which makes it accessible to both developers and non-developers.
What is Azure Data Lake Storage Gen1?
Azure Data Lake Storage Gen1 is a cloud-based storage solution that is designed for big data analytics workloads. It offers unlimited storage capacity and is capable of storing and processing petabytes of data. It is a scalable and cost-effective solution that is used by businesses of all sizes.
Connecting to the Azure Data Lake Storage Gen1 Data Source
To connect to the Azure Data Lake Storage Gen1 data source from inside Power BI, you will need to use the Power Query M Language. The following is the code that is used to establish the connection:
let
Source = AzureDataLakeStorageGen1.Contents(
“
“
[ApiUrl = “https://
),
#”Converted to Table” = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#”Expanded Column1″ = Table.ExpandRecordColumn(#”Converted to Table”, “Column1”, {“content”}, {“content”}),
#”Expanded content” = Table.ExpandBinaryColumn(#”Expanded Column1″, “content”, {“Column1”}, {“Column1”})
in
#”Expanded content”
Let’s break down the code above:
– AzureDataLakeStorageGen1.Contents: This function is used to connect to the Azure Data Lake Storage Gen1 data source. It takes three parameters: the account name, the folder path and the API URL.
– Source: This is the name of the data source that is created when the connection is established.
– #”Converted to Table”: This code is used to convert the data that is retrieved from the data source into a table.
– #”Expanded Column1″: This code is used to expand the column that contains the content of the data.
– #”Expanded content”: This code is used to expand the binary column that contains the content of the data.
Conclusion
In this article, we have explored the Power Query M Language code that is used to connect to the Azure Data Lake Storage Gen1 data source from inside Power BI. We have seen that the code is relatively simple and easy to follow. By following the steps outlined above, you should be able to connect to the Azure Data Lake Storage Gen1 data source and start working with your data in Power BI.
