Actian
Power BI is a powerful data visualization and business intelligence tool that allows users to connect to a variety of data sources. One such source is Actian, a leading provider of data management solutions. In this article, we will explore how to connect to an Actian data source from inside Power BI using Power Query M language code.
What is Actian?
Actian is a data management software company that provides solutions for data integration, management, and analytics. Their products include Actian Avalanche, a cloud-based data warehouse solution, and Actian Zen, an embedded database management system.
Why Connect to Actian from Power BI?
Connecting to an Actian data source from inside Power BI allows users to access and analyze data in real-time. This can provide valuable insights into business performance and help organizations make data-driven decisions. Additionally, Power BI’s visualization capabilities make it easy to present and share these insights with stakeholders.
How to Connect to Actian from Power BI
To connect to an Actian data source from inside Power BI, you will need to follow these steps:
1. Open Power BI and click on “Get Data” in the Home tab.
2. In the “Get Data” window, select “SQL Server” from the list of data sources.
3. In the “SQL Server database” window, enter the server name and database name for your Actian data source.
4. Click on “Advanced options” and select “SQL statement” from the drop-down menu.
5. In the “SQL statement” window, enter the following code:
let
Source = Sql.Database(“Server Name”, “Database Name”),
dbo_TableName = Source{[Schema=”dbo”,Item=”TableName”]}[Data]
in
dbo_TableName
Note: Replace “Server Name” and “Database Name” with the appropriate values for your Actian data source. Replace “TableName” with the name of the table you want to connect to.
6. Click on “OK” to connect to your Actian data source.
Understanding the Code
The code used to connect to an Actian data source from Power BI is written in Power Query M language. It consists of two parts:
1. Connecting to the data source using the “Sql.Database” function.
2. Retrieving data from the specified table using the “Source{[Schema=”dbo”,Item=”TableName”]}[Data]” syntax.
By default, Power Query will load all columns from the specified table. If you only need specific columns, you can edit the code accordingly.
Conclusion
Connecting to an Actian data source from inside Power BI is a straightforward process that can provide valuable insights into business performance. By using the Power Query M language code provided in this article, you can quickly and easily connect to your Actian data source and start analyzing your data.
