Category: PowerConnect
-
How to Install the PowerConnect License
The PowerConnect connector does not need a license. Only the PowerConnect service requires a license. To install the PowerConnect service license, just go to the conf folder where the PowerConnect service is installed and put the License.xml file there: Then you just need to restart the PowerConnect Service.
-
PowerConnect Hands-on
The objective of this hands-on manual is to help you getting started with Cubewise PowerConnect, the complete Power BI Connector for IBM Planning Analytics (TM1). PowerConnect helps you getting your data, metadata and security from TM1 into Power BI. In this user manual you will learn: This manual is available to download for free by…
-
Syncing hierarchies: TM1 and Power BI
A fundamental and very powerful feature of IBM Planning Analytics (TM1) is the use of hierarchies/consolidations, which play a crucial role in organizing and analyzing complex data sets in your model. Hierarchies are structured ways to organize data into different levels of granularity. They allow users to drill down into data, providing insights at various…
-
Ensuring Data Integrity: TM1-Power BI Security
Ensuring the security of sensitive information is paramount regardless on the application that your organization are using. If you have Power BI as your main reporting tool for your IBM Planning Analytics TM1 as your data source, let’s us then show you how these platforms approach security, and how PowerConnect can help you ensure your…
-
Introducing PowerConnect
Cubewise PowerConnect offers a tailored solution for enhancing your Power BI reporting capabilities by connecting seamlessly to IBM Planning Analytics (TM1) data sources that may not be directly supported by default connectors. Connecting to your TM1 Databases Many organizations encounter challenges when their TM1 data doesn’t align perfectly with Power BI’s native connectors. This can…
-
PowerConnect Architecture
-
PowerConnect Prerequisites
System Configuration Hardware: Operating System: Microsoft Azure App Registration For OAuth2 authentication, a Microsoft Azure App API App needs to be registered. The required scope for the app is User.Read. Admin consent needs to be applied. The redirect URL for the app is An Azure tenant admin usually does the App registration. Network Configuration for…
-
PowerConnect Sizing Guide
This guide aims to assist with sizing requirements for the PowerConnect Service. Below you will find information about how data volume transferred between IBM Planning Analytics and Microsoft Power BI impacts memory consumption in the PowerConnect Service.
-
PowerConnect Service Installation Guide
Prerequisites Windows Administrator credentials are required to complete this setup. Installation Click on “Next”. Read the license agreement, then click on “Agree”. Choose the Authentiaction Mode for Microsoft Power BI Desktop: Select the desired components. Enter the Base URL of the PowerConnect Server: Select the installation location. Default is “C:\Program Files\PowerConnect”. After the files…
-
PowerConnect Service Configuration
After the installation is completed, navigate to the installation folder, and open the copy the conf\settings.sample.yml file to conf\settings.yml. This will allow you to adjust the sample settings without having to start from scratch. Note: The PowerConnect service needs to be restarted after making changes to the configuration file. There are three sections in the…