Install name:
pybi-ray· command:pybi· import:import pybi📖 Documentation and step-by-step BI course · ⬇ Download the desktop app
PyBI is an open-source, Power BI–style business intelligence studio that you install with pip and run on your own computer. Connect data, shape it with a visual query editor, build a star-schema model, write DAX-style measures, design interactive dashboards, share a live link on your network, and export to PNG, PowerPoint, PDF or a self-contained interactive HTML file.
pip install pybi-ray
pybi run # opens PyBI Studio at http://127.0.0.1:8050
pybi demo # opens with a ready-made 3-page sales dashboard
No Python needed: every download includes its own Python and libraries, opens PyBI in your browser from the ر icon, and updates itself when a new version is released.
| Computer | File | Install |
|---|---|---|
| Windows 10/11 | PyBI-Setup.exe (zip) |
Open it, Next → Next → Install. No admin rights. |
| Mac, Apple chip (M1–M4) | PyBI-macOS-arm64.dmg |
Open it, drag PyBI to Applications. |
| Mac, Intel chip | PyBI-macOS-x86_64.dmg |
Same as above. |
| Chromebook (all ChromeOS versions, incl. 145+) | One command, no file to download | Turn on Linux (Settings → About ChromeOS → Developers), open the Terminal, paste curl -fsSL https://rafay183.github.io/pybi/install.sh \| bash. PyBI appears in the launcher. (Step by step) |
| Ubuntu, Debian, Mint | PyBI-Linux-amd64.deb · ARM: PyBI-Linux-arm64.deb |
Double-click, or run curl -fsSL https://rafay183.github.io/pybi/install.sh \| bash |
| Any other Linux | PyBI-Linux-x86_64.AppImage · ARM: PyBI-Linux-aarch64.AppImage |
chmod +x PyBI-*.AppImage, then double-click. |
Chromebook note. ChromeOS 145 and later no longer install
.debfiles by double-clicking (“Debian package is no longer supported”). Use the one-line Terminal command above; it works on every ChromeOS version and on Intel/AMD and ARM Chromebooks.First launch. Windows may say “Windows protected your PC”: click More info → Run anyway. On a Mac, if PyBI “cannot be opened”, go to System Settings → Privacy & Security and click Open Anyway. Not sure which Mac you have? Apple menu → About This Mac shows Chip: Apple M… or Processor: Intel.
(How the apps are built and updated · All versions)
Created by Muhammad Rafay Shaikh, from Pakistan.

| Area | What you get |
|---|---|
| Get data | 214 connectors: files (Excel, CSV, JSON, XML, Parquet, PDF tables, SAS/SPSS/Stata…), 50 databases (SQL Server, PostgreSQL, MySQL, Oracle, Snowflake, BigQuery, Databricks…), NoSQL, cloud storage (S3, Azure, GCS, SFTP), 70+ SaaS apps (Salesforce, HubSpot, Stripe, Shopify, Jira, Notion…), public data (World Bank, FRED, Eurostat…), REST/GraphQL/OData/Python — with preview, navigator and refresh |
| Query editor (Power Query style) | Applied steps with live preview and column quality bars: choose/remove columns, promote headers, change type, filter rows, replace values, fill up/down, remove duplicates/blanks, keep top rows, custom column, conditional column, split column, text formatting, date parts, round, group by, unpivot, merge queries, append queries, plus a JSON advanced editor |
| Model view | Drag-and-drop relationships, many-to-one with single or both cross-filter direction, active/inactive, autodetect, one-click date table |
| DAX-style formulas | Measures and calculated columns with VAR … RETURN, CALCULATE, FILTER, ALL, ALLEXCEPT, ALLSELECTED, REMOVEFILTERS, KEEPFILTERS, VALUES, SELECTEDVALUE, RELATED, RELATEDTABLE, LOOKUPVALUE, iterators (SUMX, AVERAGEX, RANKX, TOPN, CONCATENATEX), time intelligence (TOTALYTD, DATESYTD, SAMEPERIODLASTYEAR, DATEADD, PARALLELPERIOD, PREVIOUSMONTH, DATESBETWEEN, …), logic, math, text and date functions |
| Visuals (25) | Clustered / stacked / 100% column and bar, line, area, stacked area, line & column combo, waterfall, ribbon, scatter / bubble, pie, donut, treemap, funnel, gauge, card, multi-row card, KPI, table (with data bars), matrix (expand/collapse, subtotals), slicers (list, dropdown, tiles, range), text box, smart narrative |
| Interactivity | Cross-filtering by clicking any chart (Ctrl+click for multi-select), slicers (optionally synced across pages), visual / page / report filters (basic, advanced, range), tooltips, focus mode, export data behind a visual |
| Report design | Drag, resize, snap & alignment guides, pages, page sizes, 6 themes (including dark), per-visual formatting, undo/redo, copy/paste, keyboard nudging |
| Smart features | Ask your data (type “top 5 products by profit as bar”), Auto dashboard (builds a full insight page from your model), Smart narrative (auto-written summary) |
| Share | Live, read-only network link (/view) for anyone on your Wi-Fi/LAN that refreshes as you edit; editing stays on your machine |
| Export | PNG (page or all pages), PowerPoint .pptx, PDF, interactive HTML (one offline file with data, slicers and cross-filtering), .pybi project file, CSV/Excel of any table |
Open Get data to search the catalog. Each connector shows a form, a live preview, and (for databases, workbooks, folders, buckets) a Navigator to pick tables. Loaded sources remember how they were connected, so Refresh re-pulls fresh data while keeping your query steps. Passwords and tokens are stored only on your computer in ~/.pybi/credentials.json — never inside .pybi files.
Connectors marked † need an extra driver (pip install … — PyBI tells you the exact command).
File (23) — Text / CSV, Tab-separated (TSV), Fixed-width text, Excel workbook, Excel 97-2003 (.xls) †, Excel binary (.xlsb) †, OpenDocument spreadsheet †, JSON, JSON Lines / NDJSON, XML, HTML file, Parquet †, Feather / Arrow IPC †, ORC †, Avro †, SAS (.sas7bdat / .xpt), SPSS (.sav) †, Stata (.dta), HDF5 †, YAML, PDF tables, ZIP archive, Folder (combine files)
Database (50) — SQLite database, PostgreSQL †, TimescaleDB †, Greenplum †, YugabyteDB †, Supabase (Postgres) †, Neon (serverless Postgres) †, Google Cloud SQL for PostgreSQL †, Amazon Aurora / RDS PostgreSQL †, Azure Database for PostgreSQL †, Google AlloyDB †, MySQL †, MariaDB †, PlanetScale †, TiDB †, Google Cloud SQL for MySQL †, Amazon Aurora / RDS MySQL †, Azure Database for MySQL †, Microsoft SQL Server †, Azure SQL Database †, Azure Synapse Analytics (SQL) †, Microsoft Fabric Warehouse (SQL endpoint) †, Oracle Database †, IBM Db2 †, SAP HANA †, Teradata †, Vertica †, CockroachDB †, SingleStore †, Exasol †, Firebird †, ClickHouse †, Trino †, Presto †, Apache Hive †, Spark SQL (Thrift server) †, Apache Impala †, Apache Druid †, Apache Pinot †, Dremio †, Snowflake †, Amazon Redshift †, Google BigQuery †, Amazon Athena †, Databricks SQL †, DuckDB †, MotherDuck †, Microsoft Access †, ODBC (any driver) †, Other SQL database (SQLAlchemy URL) †
Web & online files (10) — Web page tables, Wikipedia tables, File from URL, Google Sheets (shared link), Google Drive file, OneDrive / SharePoint file link, Dropbox file, GitHub file, Hugging Face dataset file, RSS feed
Public data (20) — Our World in Data, World Bank indicators, FRED economic data, CoinGecko crypto markets, CoinGecko price history, Open-Meteo weather history, REST Countries, Exchange rates (ECB), Alpha Vantage stocks, Yahoo Finance †, US Census Bureau, Socrata open data (SODA), CKAN open data (data.gov…), Eurostat, OECD data (SDMX), IMF DataMapper, USGS earthquakes, NASA POWER climate, Kaggle dataset †, Hacker News top stories
NoSQL & search (16) — MongoDB †, Amazon DocumentDB †, Elasticsearch, OpenSearch, Apache Solr, Apache CouchDB, InfluxDB 2.x / Cloud, Prometheus, Redis †, Apache Cassandra / ScyllaDB †, Amazon DynamoDB †, Google Firestore †, Firebase Realtime Database, Azure Cosmos DB (NoSQL) †, Neo4j (Cypher), Supabase (REST API)
Cloud storage (13) — Amazon S3 †, MinIO †, Cloudflare R2 †, Wasabi †, DigitalOcean Spaces †, Backblaze B2 (S3 API) †, Google Cloud Storage †, Azure Blob Storage †, Azure Data Lake Storage Gen2 †, SFTP †, FTP / FTPS, WebDAV / Nextcloud †, Hadoop HDFS †
Generic & developer (4) — REST API (any JSON / CSV API), GraphQL API, OData feed, Python script
Developer tools (8) — GitHub, GitLab, Bitbucket Cloud, Azure DevOps, Linear, Sentry, Datadog metrics, Grafana (dashboards list)
Project & productivity (12) — Jira Cloud, Confluence Cloud, Trello, Asana, ClickUp, monday.com, Notion database, Airtable, Smartsheet, Coda, Baserow, Slack
Support & ITSM (9) — PagerDuty, Zendesk Support, Freshdesk, Freshservice, Intercom, ServiceNow, Help Scout, Okta users, Twilio messages
CRM & sales (9) — Salesforce (SOQL), HubSpot, Pipedrive, Zoho CRM, Freshsales, Close CRM, Copper CRM, Dynamics 365 / Dataverse, ActiveCampaign
Finance & payments (8) — Stripe, PayPal transactions, Square, Xero, QuickBooks Online, Chargebee, Paddle Billing, Lemon Squeezy
Marketing & analytics (12) — Google Analytics 4, YouTube channel videos, Meta (Facebook) Ads insights, Mailchimp, Klaviyo, SendGrid stats, Brevo (Sendinblue), Typeform responses, SurveyMonkey, Jotform, Eventbrite, Calendly
E-commerce & CMS (8) — Webflow CMS, Shopify, WooCommerce, BigCommerce, WordPress, Contentful, Strapi, Gumroad sales
HR & time tracking (5) — BambooHR, Greenhouse, Harvest, Toggl Track, Clockify
Microsoft & Google (7) — Microsoft Graph (any endpoint), SharePoint Online list, Dynamics 365 Business Central, Microsoft Planner tasks, Google Sheets (API), Google Calendar, Google Search Console
Missing something? Four universal connectors reach almost anything: REST API (auth + 6 pagination styles + nested JSON flattening), GraphQL, ODBC / SQLAlchemy URL, and Python script.
SaaS connectors use the vendor’s public REST API with a token you provide (PyBI does not run OAuth sign-in flows yet). They were built from each vendor’s API documentation and tested against a mock API, not against live accounts — if a vendor changes an endpoint, override it under Advanced options (endpoint, records path, query parameters) and please open an issue.
Install drivers in bulk with extras, e.g. pip install "pybi-ray[postgres,mysql,cloud]" or pip install "pybi-ray[all]".
pybi run # start the studio (network view link enabled)
pybi run sales.xlsx # start with a data file loaded
pybi run my_report.pybi # open a saved project
pybi run --private # only this computer can connect
pybi run --port 9000 --no-browser
pybi demo # demo dataset + dashboard
pybi export my_report.pybi -o dashboard.html # headless export to interactive HTML
python -m pybi run # same as `pybi run`
From Python or Jupyter:
import pandas as pd
import pybi
sales = pd.read_csv("sales.csv")
products = pd.read_excel("products.xlsx")
pybi.run(Sales=sales, Products=products) # opens the studio with these tables
Total Revenue = SUM(Sales[Revenue])
Profit Margin = DIVIDE([Profit], [Total Revenue])
Revenue LY = CALCULATE([Total Revenue], SAMEPERIODLASTYEAR('Calendar'[Date]))
Revenue YTD = TOTALYTD([Total Revenue], 'Calendar'[Date])
% of Total = DIVIDE([Total Revenue], CALCULATE([Total Revenue], ALLSELECTED(Sales)))
Product Rank = RANKX(ALL(Products), [Total Revenue])
Big Orders = CALCULATE([Orders], Sales[Quantity] >= 3)
Calculated column:
Sales[Cost] = Sales[Quantity] * RELATED(Products[UnitCost])
.pybi projects (a zip of raw data, steps and the report definition), and builds PPTX/PDF/HTML exports.~/.pybi/autosave.pybi./view link works on your LAN. Requests from other computers can only view (/view, read-only data); all editing APIs are restricted to the local machine. Use --private to disable network access completely..pybi files from people you trust.PyBI is not a Microsoft product and does not open .pbix files. Data is held in memory, which works well up to a few million rows depending on your machine. Not every DAX function is implemented; unsupported functions show a clear error in the formula editor.
PyBI is built in the open and contributions are very welcome — connectors tested with real accounts, visuals, DAX functions, docs and translations.
git clone https://github.com/rafay183/pybi
cd pybi
pip install -e ".[dev]"
pytest -q
pybi demo
Full documentation: rafay183.github.io/pybi. Maintainers: release steps are in docs/PUBLISHING.md. See also CHANGELOG.md and SECURITY.md.
MIT © Muhammad Rafay Shaikh. Bundles d3 (ISC license, © Mike Bostock).