Azure Time Series Insights
If you are looking to connect to an Azure Time Series Insights data source from within Power BI, you can use Power Query M language code to accomplish this task. Power Query is a powerful tool in Power BI that allows you to retrieve, transform, and load data from a variety of sources. In this article, we will discuss how to use Power Query M language code to connect to an Azure Time Series Insights data source from within Power BI.
Overview of Azure Time Series Insights
Azure Time Series Insights is a fully managed analytics, storage, and visualization service for managing telemetry data from IoT devices and other time series data sources. It enables you to store, query, and analyze large amounts of time series data in near real-time. Azure Time Series Insights provides a rich set of APIs and tools for querying and visualizing your data.
Connecting to Azure Time Series Insights from Power BI
To connect to an Azure Time Series Insights data source from within Power BI, you need to use the Power Query Editor. The Power Query Editor is a tool that allows you to query and transform data from various sources. Follow the steps below to connect to Azure Time Series Insights:
1. Open Power BI Desktop and click on Get Data.
2. Select the OData Feed option and click on Connect.
3. In the OData Feed dialog box, enter the URL of your Azure Time Series Insights data source.
4. Click on OK to connect to the data source.
Using Power Query M Language Code to Connect to Azure Time Series Insights
Once you have connected to your Azure Time Series Insights data source, you can use Power Query M language code to retrieve and transform your data. Power Query M language code is a functional programming language used to query and transform data in Power Query.
To use Power Query M language code to connect to Azure Time Series Insights, you can follow the steps below:
1. In Power BI Desktop, go to the Home tab and click on Edit Queries.
2. In the Queries pane, select the query that you want to modify.
3. Click on the Advanced Editor button to open the Power Query Editor.
4. In the Advanced Editor, enter the following code to connect to your Azure Time Series Insights data source:
let
Source = OData.Feed(“https://YOUR_ENVIRONMENT_NAME.env.timeseries.azure.com/powerbi/api/v1-preview”),
Query = Source{[Name=”YOUR_EVENT_HUB”]}[Data]
in
Query
5. Replace YOUR_ENVIRONMENT_NAME with the name of your Azure Time Series Insights environment.
6. Replace YOUR_EVENT_HUB with the name of your event hub.
The code above retrieves data from the event hub associated with your Azure Time Series Insights environment. You can modify the code to retrieve data from other sources in your environment.
Conclusion
In this article, we have discussed how to use Power Query M language code to connect to an Azure Time Series Insights data source from within Power BI. We hope that this article has been helpful in showing you how to retrieve and transform data from your Azure Time Series Insights environment using Power BI. With the right tools and techniques, you can gain powerful insights from your time series data and make informed decisions for your business.
