AtScale cubes
Power Query is a powerful data transformation and cleansing tool used in Power BI and Excel. Power Query also supports a wide range of data sources, including databases, files, web services, and more. In this article, we will explore how to connect to AtScale cubes data source using the Power Query M language code from inside Power BI.
What is AtScale cubes?
AtScale is a business intelligence platform that provides a universal semantic layer for data access, governance, and analytics. AtScale cubes is a multi-dimensional data model that enables business users to analyze data from different sources using familiar tools and techniques.
Why Connect to AtScale cubes from Power BI?
Connecting to AtScale cubes from Power BI allows you to analyze and visualize data from multiple sources in a single report. You can create interactive visualizations that enable business users to explore and analyze data in real-time. This integration provides a seamless experience that empowers users to make data-driven decisions.
Connecting to AtScale cubes Data Source from Power BI
To connect to AtScale cubes data source from Power BI, you need to follow these steps:
1. Open Power BI Desktop and click on the “Get Data” button in the Home tab.
2. In the “Get Data” window, select “AtScale cubes” as the data source.
3. In the “AtScale cubes Connector” window, enter the URL of your AtScale server and click on “OK”.
4. In the “Connect to Data” window, select the cube you want to connect to and click on “Load”.
5. Power BI will load the data from the selected cube into the “Query Editor” window.
6. In the “Query Editor” window, you can perform various data transformation and cleansing operations using the Power Query M language code.
Power Query M Language Code for Connecting to AtScale cubes Data Source
To connect to AtScale cubes data source using the Power Query M language code, you need to follow these steps:
1. Open Power BI Desktop and click on “Blank Query” in the “Home” tab.
2. In the “Query Editor” window, click on “View” and select “Advanced Editor”.
3. In the “Advanced Editor” window, paste the following code:
let
Source = Cube.Contents(“https://[AtScale Server Name]:8443″, [CubeName=”[Cube Name]”])
in
Source
4. Replace “[AtScale Server Name]” with the URL of your AtScale server and “[Cube Name]” with the name of the cube you want to connect to.
5. Click on “Done” to save the changes.
6. Power BI will load the data from the selected cube into the “Query Editor” window.
7. In the “Query Editor” window, you can perform various data transformation and cleansing operations using the Power Query M language code.
Conclusion
In this article, we have explored how to connect to AtScale cubes data source using the Power Query M language code from inside Power BI. By connecting to AtScale cubes from Power BI, you can create interactive visualizations that enable business users to explore and analyze data in real-time. This integration provides a seamless experience that empowers users to make data-driven decisions.
