| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1508 |
| Technical Name |
byteloom_generative_dashboard |
| License | OPL-1 |
| Website | https://techfinna.com |
| Versions | 16.0 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1508 |
| Technical Name |
byteloom_generative_dashboard |
| License | OPL-1 |
| Website | https://techfinna.com |
| Versions | 16.0 17.0 18.0 |
TechFinna
Byteloom AI Power Analytics & Intelligent Export for Power BI
Build AI dashboards inside Odoo. Create flexible datasets without writing joins. Push to Power BI Cloud in 10k-row batches, schedule auto-refresh, and embed Power BI tiles back in Odoo.
AI Dashboards in Odoo
Push to Power BI
10k-Row Batching
Auto-Refresh
Embed in Odoo
What’s Inside — AI Dashboards + Power BI Exports
Precisely what teams need — no fluff.
- Dataset Builder: start from any model (e.g., sale.order.line), tick fields; related tables unfold automatically.
- Durable SQL View: your selections become a single, reusable view — no CSV juggling or hand-joins.
- Power BI Push: create/map push datasets, upload rows in 10,000 record batches with safe retry/backoff.
- Scheduler: per-dataset refresh interval + on/off toggle and a manual Push now.
- Embed: show Power BI tiles securely inside an Odoo dashboard view.
Dataset Manager — Push & Refresh from One Place
List of generated SQL views with sync controls.
- Per-dataset control: refresh toggle, interval, manual sync.
- Logging: failed batch, retry count, and HTTP details in Odoo logs.
- Mapping: create or map to existing Power BI datasets by workspace.
Power BI Push & Auto-Refresh — Built for Scale
- 10k-row batching: stream large views safely; memory stable.
- Retry/backoff: network hiccups won’t corrupt the dataset.
- Incremental append: optional date/id watermark to push only new rows.
- No gateway: direct push-dataset API from your Odoo server.
chunksize = 10_000 # rows
for batch in paginate(sql_view, chunksize):
try:
post_to_power_bi(batch) # createRows/append
except TransientError:
retry_with_backoff(batch)
Datasets
Dataset
Rows
Auto
Interval
Actions
Power BI Inside Odoo — No Context Switching
- Embed tiles: show Power BI charts next to native Odoo KPIs.
- Secure: tokens/IDs stored in Odoo system parameters.
- Unified: AI charts (Odoo) + Power BI visuals on one page.
How It Works — End to End
- Build dataset: pick base model → tick fields → related tables auto-unfold.
- SQL view: generated once; reused for Odoo charts and Power BI push.
- Push: create/map push dataset → upload in 10k chunks with retry.
- Refresh: set interval + toggle per dataset; manual Push now.
- Embed: add Power BI tiles to an Odoo dashboard view.
Technical Details — For Admins
- Security: Power BI tokens & config stored in ir.config_parameter.
- Schema drift: field remap checks; warnings on conflicts.
- Error handling: per-batch logging; resumable on next run.
- Performance: server-side pagination; constant memory profile.
- Support: tested on Odoo 18; SQL-view based.
Talk to TechFinna
Email: info@techfinna.com
Website: techfinna.com
© TechFinna — Byteloom AI Power Analytics & Intelligent Export for Power BI
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