Power BI Connector
The Power BI Connector module enables seamless integration between Odoo and Microsoft Power BI, allowing users to connect and manage Workspaces, Datasets, Reports, Dashboards, Eventhouses, KQL Databases, and KQL Tables directly from Odoo. It simplifies business intelligence, analytics, reporting, and data synchronization by providing a centralized platform to manage Power BI resources and visualize business data efficiently.
Speeduplight provides FREE 90 Days Support for any queries, doubts, or bug fixes (excluding data recovery), applicable from the date of purchase.
✨ Key Features
- 🔗 Power BI Connection Management
- 📂 Workspace Management
- 📊 Dataset Management
- 📈 Report Integration
- 📋 Dashboard Integration
- 🏢 Eventhouse Management
- 🗄️ KQL Database Management
- 📑 KQL Table Management
- ⚡ Data Synchronization
📷 Power BI Dashboard
👉 Monitor all Power BI resources from a centralized dashboard in Odoo.
📷 Power BI Connection Configuration
👉 Configure and manage secure Microsoft Power BI connections by providing Tenant ID, Client ID, and Client Secret credentials.
📷 Azure App Registrations
👉 Navigate to the Microsoft Azure Portal and access the App Registrations section to create a new application for Power BI integration. This application provides the Tenant ID, Client ID, and Client Secret required to establish a secure connection between Odoo and Microsoft Power BI.
📷 Register New Azure Application
👉 Click the New Registration button to create a new Azure application for Power BI integration.
📷 Copy Tenant ID and Client ID
👉 Open the registered Azure application and copy the Application (Client) ID and Directory (Tenant) ID. These credentials are required to configure the Power BI connection in Odoo.
📷 Open Client Credentials
👉 Open the Azure App Registration overview page and click on Client Credentials. This section allows you to create and manage client secrets.
📷 Create and Copy Client Secret
👉 Click New Client Secret to generate a secret key. After creation, copy the Value immediately and save it securely. This value must be entered in the Client Secret field of the Power BI Connector configuration.
📷 Test Power BI Connection
👉 After entering the Tenant ID, Client ID, and Client Secret, click the Test Connection button to validate the Microsoft Azure credentials. Upon successful verification, the system confirms that the connection is ready for Power BI authentication and workspace synchronization.
📷 Connect Power BI Account
👉 After successfully validating the Azure credentials, click Connect Power BI to authenticate with your Microsoft account. Once connected, Odoo securely stores the access token, displays the connection status, token validity, expiry information, and enables workspace synchronization for Power BI resources.
📷 Create Power BI Workspace
👉 Enter a unique Workspace Name and click the Create Workspace button. The system will create a new Power BI workspace
📷 Workspace Available in Power BI
👉 After creating the workspace from Odoo, it is automatically synchronized with Microsoft Power BI.
📷 Create and Configure Table
👉 Navigate to Workspaces → Tables and create a new table. Enter the table name, select the Odoo model, configure filter rules, map the required fields, and define the schema structure. Once the configuration is completed, save the table to prepare it for data synchronization with Microsoft Power Bi.
📷 Create Dataset
Create a new dataset by entering the dataset name, selecting the Power BI connection, choosing the target workspace, and adding the required tables. The dataset acts as a logical collection of tables that will be synchronized and used for reporting and analytics in Microsoft Power BI.
📷 Dataset Successfully Created in Power BI
👉 After creating the dataset in Odoo, the selected tables are automatically synchronized with Microsoft Power BI. The newly created dataset appears inside the selected workspace as a Semantic Model, making it available for report creation, dashboard development, and advanced analytics.
📷 Create Reports from Dataset
👉 Open the generated dataset in Microsoft Power BI to view all synchronized tables and fields. Expand the dataset to verify the imported columns and data structure. Click Explore → Create a Blank Report to start building interactive reports, charts, KPIs, and dashboards using the synchronized Odoo data.
📷 Create Power BI Report
👉 Use the synchronized dataset fields to build interactive Power BI reports and dashboards. Select the desired visualization, drag and drop Odoo fields into the report canvas, configure charts, filters, and KPIs, then save the report for business analysis and decision-making.
📷 Create Power BI Dashboard
👉 After creating and saving your Power BI report, pin visualizations such as KPI cards, charts, graphs, and tables to a dashboard.
📷 Import Power BI Reports & Dashboards
👉 After creating reports and dashboards in Microsoft Power BI, open the Workspace record in Odoo and click Import Reports or Import Dashboards. The system retrieves all available Power BI reports and dashboards from the selected workspace and synchronizes them into Odoo for centralized management and access.
📷 View Power BI Reports in Odoo
👉 Open any imported Power BI Report directly from Odoo.
📷 Power BI Dashboard Viewer
👉 View imported Power BI Dashboards directly inside Odoo.
📷 Microsoft Fabric Integration
👉 Access Microsoft Fabric resources directly from Odoo. Manage Eventhouses, KQL Databases, and KQL Tables from a centralized interface and synchronize Fabric assets with your Power BI environment.
📷 Create Microsoft Fabric Eventhouse
👉 Create and manage Microsoft Fabric Eventhouses directly from Odoo. Select a Power BI Workspace, define the Eventhouse name, and synchronize Fabric resources for real-time analytics and data streaming scenarios.
📷 Create Microsoft Fabric KQL Database
👉 Create and manage Microsoft Fabric KQL Databases directly from Odoo. Select a Power BI Workspace and Eventhouse, then create a KQL Database.
📷 Create Microsoft Fabric KQL Table
👉 Create and manage Microsoft Fabric KQL Tables directly from Odoo. Select a KQL Database, choose the Odoo model or table to synchronize.
📷 View Eventhouse Database & Tables in Microsoft Fabric
👉 After creating the Eventhouse, KQL Database, and KQL Table from Odoo, the resources are automatically synchronized with Microsoft Fabric.
Our Odoo Services
Consulting
Development
Migration
Support
Integration
Training
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 3405 |
| Technical Name |
sp_power_bi_connector |
| License | OPL-1 |
| Website | https://speeduplight.com/ |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module