Bizview v26.3 Enhancements
This topic describes the significant enhancements in Bizview v26.3.
Caution: Starting with Bizview v24.1, feature enhancements are no longer available to on-premise users.
Power BI Integration
This release introduces native Power BI integration for Bizview, enabling Power BI Desktop and Web users to connect directly to Bizview Dataviews using Power BI’s built-in OData Feed connector. No additional connector purchase or third-party installation is required.
When a Power BI user enters the Bizview OData API URL in the OData Feed dialog and selects Organizational account as the authentication method, Power BI signs in using Azure Active Directory (Azure AD) credentials. On connection, Power BI automatically calls the Bizview metadata endpoint and populates the Navigator pane with all available Dataviews and their column structures — no manual field entry is required. The user selects the Dataviews to import and loads the data directly into Power BI for reporting and analysis.
The OData V2 endpoint supports standard OData query options, including column selection and row filtering, which Power BI uses automatically in DirectQuery mode to retrieve only the data relevant to the report. For large Dataviews containing thousands of rows, the endpoint uses server-driven pagination, loading data in batches of 1,000 rows and following pages automatically until the full dataset is loaded. This eliminates connection timeouts regardless of Dataview size.
Authentication is handled through Azure AD. A one-time admin consent step is required in the customer’s Azure AD tenant before users can connect. Once consent is granted, any user in that tenant with a valid Bizview account can authenticate using their organizational credentials. No per-user configuration is required after the initial setup.
Key Benefits
- Connect Power BI Desktop and Web directly to Bizview Dataviews using the built-in OData Feed connector — no additional connector purchase required.
- Automatic schema discovery populates the Power BI Navigator with Dataview names and column types on connection, with no manual field mapping.
- Server-driven pagination loads large Dataviews reliably without timeouts, regardless of dataset size.
- Azure AD authentication provides secure, organization-wide access using existing credentials, with no per-user setup after initial admin consent.
For more information, see Power BI Integration.
AI SQL Optimizer
This release introduces the AI SQL Optimizer, a new AI-powered capability in the SQL Query Dataview editor that helps system administrators write more efficient SQL queries.
Note: The AI SQL Optimizer is available on the Bizview Platform only, and is accessible to system administrators who have access to Dataviews.
The AI SQL Optimizer is accessed from the AI Optimize button in the SQL Query Dataview editor toolbar. Clicking AI Optimize opens the AI SQL Optimizer panel within the editor area. The AI agent reads the current SQL query, retrieves the schema metadata for the configured data source, and analyzes the query execution plan to identify performance issues such as missing indexes, inefficient joins, scalar subqueries, and redundant lookups.
Once analysis is complete, the panel displays a structured set of findings. Each finding includes a category, severity level, description of the current problem, and the recommended optimization. Below the findings, the panel displays schema recommendations and a side-by-side view showing the original SQL on the left and the optimized SQL on the right, with removed lines highlighted in red and added lines highlighted in green.
Clicking Accept replaces the editor content with the optimized SQL. Clicking Discard closes the panel with no changes to the editor. Clicking Accept does not save the Dataview — Save must be clicked separately to commit the change. Once saved, the original query cannot be recovered from within the editor.
Each AI SQL Optimizer session is automatically saved to the Lineos chat history. The full session — including the agent’s findings, schema recommendations, and the suggested SQL — is available for review at any time from the Lineos panel, without needing to re-run the analysis.
Key Benefits
- Identify and resolve SQL performance issues — missing indexes, inefficient joins, and redundant subqueries — directly in the Dataview editor without leaving Bizview.
- AI analysis is based on the actual data source schema and query execution plan, producing accurate, schema-aware recommendations rather than generic suggestions.
- Side-by-side view makes it easy to review exactly what changed and why before deciding whether to accept the suggestion.
- The editor content does not change until Accept is explicitly clicked — administrators stay in full control of their queries at all times.
- Each optimization session is saved to Lineos chat history, providing a persistent record of all findings and suggested queries for future reference.
For more information, see AI SQL Optimizer.
What’s Fixed?
For a list of resolved issues in this release, see the Bizview v26.3 Release Notes.