OpenBI

OpenBI Studio

Release history.
Newest first.

The notes each release showed in OpenBI Studio’s update bar, on Windows and on a Mac.

68 releases, from 0.3.12 on 16 October 2026 to 0.3.79 on 8 November 2026

0.3.79

Windows and Mac

  • Claude no longer opens OpenBI Studio by itself: the studio starts when Claude first uses one of its tools, not when a Claude session starts
  • M checked against Power BI Desktop on 67 behaviours and corrected wherever Desktop answers otherwise: cultures, Turkish and Polish capitals, text encodings, random numbers, GUIDs
  • Locale for import in Model settings: M reads and writes numbers and dates in the project's locale, as Power BI Desktop does; Change type has Using locale
  • Excel dates are read as Power BI Desktop reads them; Sql.Database navigates by schema as Desktop does; OData.Feed sends the headers you give it
  • Exchange.Contents: mail, calendars with sub-calendars, meeting requests and local times as Desktop gives them; Tasks needs a permission the sign-in lacks (known issue)
  • After the upgrade, tables whose queries use a corrected M function show the refresh bar once: a refresh clears it
  • The formula bar's hints cover all 482 OAX functions; the docs have a page for every M function and 8 new OAX pages
  • 15 known differences from Power BI Desktop remain in M, each on its function's page: see www.openbi.no/docs/reference/releases/

0.3.78

Windows and Mac

  • New: NETWORK.ROLLUP multiplies along every path and adds them up: bills of materials, ownership through chains and cost allocation, checked against Statistics Norway's and Statistics Finland's tables
  • Network functions read their rows about 10 times faster, with the same answers
  • The query plan shows each network function's steps: reading the rows, numbering the nodes, the graph work and building the result
  • Matrices fit their card: headings wrap, and a wide matrix scrolls inside its card
  • A visual's query can use {{filters except 'Table'[Column]}} to keep every filter but one, and {{values 'Table'[Column]}} to read that column's selection
  • Slicers on the same table no longer blank each other
  • report_edit removes an attribute set to null

Windows only

  • When the PC's screen is locked, copying and pasting say so instead of saying the clipboard is busy

Mac only

  • An agent's page checks, pictures and PDFs run at normal speed while the studio is minimized

0.3.77

Windows and Mac

  • Network functions give the same answer whatever order the rows come in: nodes are now numbered by their values, not by the order the rows arrived
  • A once-off change from 0.3.76: some communities move (few nodes where groups are clear), rows come out in the nodes' order, and ties, layouts and SIR runs can differ
  • New: NETWORK.RINGS finds groups held together by triangles, such as fraud rings. NETWORK.WEAKPOINTS finds the nodes and links whose loss splits a network
  • New: NETWORK.CUTS finds a network's weakest cuts by capacity. NETWORK.PREDICT scores the links most likely missing. NETWORK.SIMILARITY can keep only the most similar pairs
  • Notebooks can use Open Graph, the graph library behind the NETWORK functions: a Graph from the model's rows with communities, paths, flows, embeddings and spreading, and every Open Graph function
  • Leiden communities are found about twice as fast on Macs
  • Fast greedy communities on large networks come much closer to the reference implementation's groupings
  • Paste page and pasting visuals wait a moment while another program holds the clipboard, and say so if it stays busy

0.3.76

Windows and Mac

  • Network analysis runs on Open Graph, Norway Analytics' own graph library: much faster on all cores, same answers for paths, centrality, Louvain, Leiden, label propagation, walktrap, edge betweenness
  • Network drawings (NETWORK.LAYOUT) are laid out differently, with the same quality
  • Infomap and fast greedy may group some networks differently: Infomap finds equal or better groupings by its own measure, and fast greedy can group large networks differently
  • Max flow (NETWORK.FLOW) may route the flow over different links, with the same total and the same cut
  • NETWORK.SENSITIVITY is now exact and much faster, and answers larger networks
  • Network results no longer change when many users query at once

0.3.75

Windows and Mac

  • Fuzzy matching in M: Table.FuzzyJoin, FuzzyNestedJoin, FuzzyGroup and AddFuzzyClusterColumn with Power BI Desktop's scores (a few pairs close to the threshold can differ)
  • New functions: SKEW.S, SKEW.P, KURT.S, KURT.P and their X forms, and NETWORK.LINKS, NETWORK.COMPARE, NETWORK.MATCH and NETWORK.SENSITIVITY
  • PDFs keep their links, lists and gradients, with margins, fit to the page, and headers and footers with page numbers; what is only for the screen stays off the paper
  • OpenBI's query editor is now called Open Query (Transform data), and an agent that applies its queries closes Transform data as Close & apply does
  • Azure Storage: AzureStorage.Blobs, DataLake and DataLakeContents, the four sign-in methods and organizational account, Excel files from cloud storage or the web
  • Report pages speak all seven languages, matrices show a Top N, and percentile marks, month axes, KPI sparklines and mark labels draw as asked

Windows only

  • At start the studio repairs old agent connections in other apps' settings files, keeping a backup beside each; agents connect through OpenBI.Studio.exe --mcp

Mac only

  • At start the studio repairs old agent connections in other apps' settings files, keeping a backup beside each; agents connect through the studio's --mcp bridge

0.3.74

Windows and Mac

  • 16 more functions give Power BI Desktop's answers, among them LOOKUPVALUE and CONTAINS over related tables, FIRSTNONBLANK over a table, RANDBETWEEN, the PATH functions and ISONORAFTER
  • Different numbers than 0.3.73: ACCRINT, VDB, ODDFPRICE, ODDFYIELD, HISTOGRAM and LINESTX now give Power BI Desktop's answers, so reports that use them can change
  • KEEPFILTERS where Power BI does not take it, and NONVISUAL on a column the query does not group by, now give an error as in Power BI Desktop instead of an answer
  • PATH over a parent that is no row's id keeps its answer and now warns as the model loads, naming the rows (Power BI Desktop does not load such a model)
  • Agents copy pages between projects (report_import, report_copy) and whole projects (project_copy), and an agent's first call after a project opens waits for its engine
  • Filters that look for the first or last value with data, such as FIRSTNONBLANK by date with a measure, run about twice as fast, with the same results

Windows only

  • Several visuals copied at once (Ctrl+A, Ctrl+click or a selection box) and pasted into another page, project or window; Copy page, Paste page and Import pages bring whole pages

Mac only

  • Several visuals copied at once (Cmd+A, Cmd+click or a selection box) and pasted into another page, project or window; Copy page, Paste page and Import pages bring whole pages

0.3.73

Windows and Mac

  • OpenBI's formula language is now called OAX, Open Analytical Expressions: the same DAX-compatible formulas, and the DAX tab is now the OAX tab
  • Date-times keep their fractions of a second as Power BI Desktop does, to 1/300 of a second: the grids show them, filters on them match and date-time arithmetic gives Desktop's answers
  • UTCNOW and UTCTODAY now give UTC time, and NOW, TODAY, UTCNOW and UTCTODAY give one moment for a whole query
  • Plug-ins no longer receive the studio's agent key: one that needs the agent endpoint asks you once for a key of its own, limited to the tools it names
  • Map backgrounds and page images come through your computer's own web connection and proxy settings, and are kept as long as the map servers allow
  • Two OpenBI Studio windows no longer overwrite each other's settings: the Publish dialog keeps your servers
  • RAND and RANDBETWEEN give a new number at each evaluation, as in Power BI Desktop

Mac only

  • On a Mac, OpenBI Studio now runs only plug-ins signed by Norway Analytics or a publisher your IT allows; an unsigned plug-in stops running until IT allows it

0.3.72

Windows and Mac

  • Describe your measures: the Model view lists the measures without a description, your agent can propose descriptions for you to accept or drop, and Publish and Share remind you
  • Security: row-level and object-level security can no longer be bypassed with hand-written DAX, and a formula nested too deep gives an error instead of stopping the engine
  • A query you cancel, or whose page you close, now stops inside the engine instead of running on, and Excel's query time limit is kept
  • Faster answers on large tables: totals grouped by several columns, distinct counts and the filters over them run several times faster, with the same results
  • Power Query's date filters on Parquet and lake tables, such as rows up to #date(1998, 9, 2), now run inside DuckDB: a fraction of a second and little memory instead of seconds and gigabytes

0.3.71

Windows and Mac

  • Live models on Analysis Services: people who are not the server's administrators now get its formats, sort orders, date table and relationships, as in Power BI
  • Charts on live models show months in calendar order for every user, no longer alphabetically
  • When a server shares measure formulas only with its administrators, the formula bar, model view and Data pane say so, and so does the agent

Mac only

  • openbi credential set in Terminal no longer shows the password as you type it

0.3.70

Windows and Mac

  • Notebook papers (PDF) draw line charts and numbers right on any language setting, such as Danish, and fit wide tables
  • Filters pane: a filter left with nothing chosen stays (is (All)), and the eraser beside the x clears it
  • An agent working in the studio no longer takes your keyboard or brings the studio to the front
  • Connect ChatGPT: ChatGPT's desktop app and Codex get OpenBI Studio in one click, from the Agent window
  • The agent key is never shown in full, and Change key says first which clients it will stop
  • SQL in the DAX view runs as written, and its starter queries work on any model
  • Map files and spatial functions are refused in plain words, in previews and every refresh

Windows only

  • Share the model says where your own files are, with Show in Explorer

Mac only

  • Share the model says where your own files are, with Show in Finder

0.3.69

Windows and Mac

  • Live models: an answer asked just after the engine starts is kept, no longer dropped at once
  • Security: SQL's predict() reads and writes a prediction's files only inside the project
  • The bill of materials installed with the studio (sbom.html) no longer loads fonts from the internet

Windows only

  • Report charts no longer shake at a browser zoom such as 90 %, 110 % or 125 %, in Edge, Chrome and the studio
  • The studio no longer stays unclickable after Transform data's Close & apply closes while its data loads
  • A model another program is saving at that moment no longer fails to open or reload with Cannot read
  • Notebooks no longer redraw every step each time an edit is saved

Mac only

  • Report charts no longer shake at some browser zooms, in Safari, Chrome, Edge and the studio

0.3.68

Windows and Mac

  • Power Query fixed: Date.StartOfMonth and StartOfQuarter gave the year's start, Number.RoundUp rounded down, week functions ignored the culture; refresh the tables the studio names
  • The engine no longer stops when two agents change a model at once; a stopped engine starts again by itself, and a damaged data snapshot is never used
  • Two active relationships between the same tables are refused as Power BI Desktop refuses them, with a one-click fix, and USERELATIONSHIP answers as in Power BI
  • Hide pages as in Power BI; a report's PDF prints each page in full, with its header and every table row, and slide PDFs keep all their pages
  • Predictions and plans in the model's language: bands and reasons named, forecast dates that fit the data, plan review pages for yes/no plans
  • Connect Cursor to OpenBI Studio in one click from the Agent window; live Power BI models reconnect at once after you sign in again
  • Security: a crafted data snapshot, such as one in a shared model, can no longer crash the engine

Windows only

  • Transform data: SQL on Parquet files whose paths have spaces works, and deleting a query no longer fails

Mac only

  • A right-click menu on every code editor: Undo, Redo, Cut, Copy, Paste, Select All, and Format for DAX

0.3.67

Windows and Mac

  • Read Power BI models live on a Mac: sign in with Microsoft once, then read your Premium/PPU and Pro workspaces' models
  • Visual-level filters on measures work as in Power BI, such as show items when the value is greater than 0, and totals of Top N tables now follow Power BI
  • Notebooks run walk-forward backtests and give bootstrap intervals for AUC
  • Plug-ins are separate downloads now, from www.openbi.no/sdk/: add one with Install a plug-in in the studio
  • Security: CVE-2026-111497 is fixed, in DuckDB's and in .NET's Brotli decoder
  • Charts no longer grow on narrow pages in Safari and in the studio on a Mac
  • Monte Carlo simulations take 5,000 paths by default (was 2,000), fewer only for very long horizons
  • A prediction version saved with a name column shows who is scored beside the key; versions saved before answer exactly as approved

0.3.66

Windows and Mac

  • A Cox model with a level that has no events says its coefficient may be infinite, as R does, and gives its interval as 0 to Infinity
  • Forecast dates are dates: a PREDICT forecast's Date, renamed or rebuilt, draws on a date axis, and agents' queries get it as a date
  • Forest charts with extreme intervals stay readable: such an interval is cut at the axis' end with an arrow, and every term is named
  • Band charts draw their months in date order, even when the query does not sort them
  • List slicers with many thousands of values draw at once and reach every value by scrolling
  • A retired prediction version with none in use no longer scores on pages, in a model's tables, in Get data or on OpenBI Server

Mac only

  • Live Analysis Services models are read on a Mac too, through the server's msmdpump https address; Power BI models are still read on Windows
Also in its notes, from earlier releases (2)
  • Charts no longer pulsate: 0.3.64 resized some charts on every frame (Server 0.1.32 too); they are sized as in 0.3.63 again
  • Dates show as the server formats them, such as Sep 2026 for mmm yyyy, in cards, charts and tables alike Windows only

0.3.65

Windows and Mac

  • Charts no longer pulsate: 0.3.64 resized some charts on every frame (Server 0.1.32 too); they are sized as in 0.3.63 again
Also in its notes, from earlier releases (9)
  • Dates show as the server formats them, such as Sep 2026 for mmm yyyy, in cards, charts and tables alike
  • A prediction that scores nothing now says why (the version, its scoring date and how to set it) instead of showing an empty page
  • Prediction versions nobody has approved yet can be tested in the studio, but never reach a report page
  • A retired prediction version no longer scores on report pages, in a model's tables or on OpenBI Server; the studio's own tests can still try it
  • An operations research plan solved by its number must be approved first
  • Formats that DAX reads otherwise than Excel are pointed out as you write them: mm:ss is month and seconds in DAX (write nn:ss), and tt is not AM/PM Windows only
  • Predictions on live models show the names the server has and say what they are, and agents get only queries that really run on a live connection Windows only
  • Answers now match Power BI on variance and standard deviation (VARX.P, STDEVX.P and the like), as they already did on Windows Mac only
  • Live Analysis Services and Power BI models are read on Windows today; on a Mac the studio says so instead of asking you to sign in Mac only

0.3.64

Windows and Mac

  • Dates show as the server formats them, such as Sep 2026 for mmm yyyy, in cards, charts and tables alike
  • A prediction that scores nothing now says why (the version, its scoring date and how to set it) instead of showing an empty page
  • Prediction versions nobody has approved yet can be tested in the studio, but never reach a report page
  • A retired prediction version no longer scores on report pages, in a model's tables or on OpenBI Server; the studio's own tests can still try it
  • An operations research plan solved by its number must be approved first
  • Formats that DAX reads otherwise than Excel are pointed out as you write them: mm:ss is month and seconds in DAX (write nn:ss), and tt is not AM/PM

Mac only

  • Answers now match Power BI on variance and standard deviation (VARX.P, STDEVX.P and the like), as they already did on Windows
  • Live Analysis Services and Power BI models are read on Windows today; on a Mac the studio says so instead of asking you to sign in
Also in its notes, from earlier releases (2)
  • Predictions on live models show the names the server has and say what they are, and agents get only queries that really run on a live connection Windows only
  • Churn bands are chances now: High 50 % or more, Medium 20 to 50 %, Low under 20 %; a version approved before says its bands are ranks Windows only

0.3.63

Windows and Mac

  • Predictions on live models show the names the server has and say what they are, and agents get only queries that really run on a live connection
  • Churn bands are chances now: High 50 % or more, Medium 20 to 50 %, Low under 20 %; a version approved before says its bands are ranks
  • Suggesting a prediction tries each measure on your data first and leaves out those that can't tell what a customer did lately, saying why
  • A forecast's total no longer shows a range made by adding up each series' range, which overstated it; its error is shown beside the per-series one
  • Report pages with a broken attribute (a value cut short at a quote, an attribute written twice) are said as errors, and editing fixes the whole attribute
Also in its notes, from earlier releases (4)
  • Live models: answers over about 16,000 values lost rows in 0.3.55 to 0.3.61 (empty, wrong, an error, or the engine stopped); they are read whole again, and answers kept from those versions are dropped
  • Back up a lake to Azure Blob Storage, Amazon S3, Google Cloud Storage or a folder: five guided steps once, then one click or a daily schedule; Verify checks a backup, Restore makes a new lake from it
  • OPTIMIZE and VALUATION results larger than 256 KB are read whole again Windows only
  • Buttons sit in Apple's order everywhere (the default one on the right, Cancel beside it), and lists have a softer header row in dark mode Mac only

0.3.62

Windows and Mac

  • Live models: answers over about 16,000 values lost rows in 0.3.55 to 0.3.61 (empty, wrong, an error, or the engine stopped); they are read whole again, and answers kept from those versions are dropped
  • OPTIMIZE and VALUATION results larger than 256 KB are read whole again
Also in its notes, from earlier releases (7)
  • Back up a lake to Azure Blob Storage, Amazon S3, Google Cloud Storage or a folder: five guided steps once, then one click or a daily schedule; Verify checks a backup, Restore makes a new lake from it
  • The engine no longer stops when two changes to the model are saved at the same moment (for example two agents at once); a project it left unable to open opens again
  • OpenBI Lake: keep your data in a lake of your own (a folder, a NAS, S3 or MinIO, Azure or Google Cloud Storage) and read any table as it was at any version
  • Models that would not open now open (relationships between columns of different types, Enter data tables, a calculated column that fails) and load the right data
  • Answers now match Power BI Desktop in more cases: REMOVEFILTERS with USERELATIONSHIP, calculation groups, CROSSFILTER both ways, time intelligence
  • DuckDB 2.0, its new long-term release, now reads, folds and previews your Power Query and SQL tables Windows only
  • Buttons sit in Apple's order everywhere (the default one on the right, Cancel beside it), and lists have a softer header row in dark mode Mac only

0.3.61

Windows and Mac

  • Back up a lake to Azure Blob Storage, Amazon S3, Google Cloud Storage or a folder: five guided steps once, then one click or a daily schedule; Verify checks a backup, Restore makes a new lake from it

Windows only

  • A model's table can read straight from a lake, held at the version its last refresh read, and agents create, load, read and back up lakes with their own tools

Mac only

  • Buttons sit in Apple's order everywhere (the default one on the right, Cancel beside it), and lists have a softer header row in dark mode
Also in its notes, from earlier releases (6)
  • The engine no longer stops when two changes to the model are saved at the same moment (for example two agents at once); a project it left unable to open opens again
  • OpenBI Lake: keep your data in a lake of your own (a folder, a NAS, S3 or MinIO, Azure or Google Cloud Storage) and read any table as it was at any version
  • Get data, OpenBI Lake reads a lake; Transform data, Save to lake writes a query into one (replace, append or incremental), checked before anything is written
  • Models that would not open now open (relationships between columns of different types, Enter data tables, a calculated column that fails) and load the right data
  • Answers now match Power BI Desktop in more cases: REMOVEFILTERS with USERELATIONSHIP, calculation groups, CROSSFILTER both ways, time intelligence
  • DuckDB 2.0, its new long-term release, now reads, folds and previews your Power Query and SQL tables

0.3.60

Windows and Mac

  • The engine no longer stops when two changes to the model are saved at the same moment (for example two agents at once); a project it left unable to open opens again
  • Models that would not open now open (relationships between columns of different types, Enter data tables, a calculated column that fails) and load the right data
Also in its notes, from earlier releases (6)
  • OpenBI Lake: keep your data in a lake of your own (a folder, a NAS, S3 or MinIO, Azure or Google Cloud Storage) and read any table as it was at any version
  • Get data, OpenBI Lake reads a lake; Transform data, Save to lake writes a query into one (replace, append or incremental), checked before anything is written
  • A model's table can read straight from a lake, held at the version its last refresh read, and agents create, load and read lakes with their own tools
  • Power Query reads Delta tables and their versions (DeltaLake.Table, Value.Versions), and Folder.Contents lists subfolders as Power Query does
  • Answers now match Power BI Desktop in more cases: REMOVEFILTERS with USERELATIONSHIP, calculation groups, CROSSFILTER both ways, time intelligence
  • DuckDB 2.0, its new long-term release, now reads, folds and previews your Power Query and SQL tables

0.3.59

Windows and Mac

  • OpenBI Lake: keep your data in a lake of your own (a folder, a NAS, S3 or MinIO, Azure or Google Cloud Storage) and read any table as it was at any version
  • Get data, OpenBI Lake reads a lake; Transform data, Save to lake writes a query into one (replace, append or incremental), checked before anything is written
  • A model's table can read straight from a lake, held at the version its last refresh read, and agents create, load and read lakes with their own tools
  • Power Query reads Delta tables and their versions (DeltaLake.Table, Value.Versions), and Folder.Contents lists subfolders as Power Query does
  • Models that would not open now open: relationships between columns of different types, Power BI Desktop's Enter data tables, a calculated table or column that fails
  • Loading gives the right data: -1 and -2 in one column stay apart, and a blank key gives its table a blank row, as in Power BI
  • Answers now match Power BI Desktop in more cases: REMOVEFILTERS with USERELATIONSHIP, calculation groups, CROSSFILTER both ways, time intelligence
  • DuckDB 2.0, its new long-term release, now reads, folds and previews your Power Query and SQL tables

0.3.58

Windows and Mac

  • A Power BI model whose tables read from two or more servers or databases opens again: since 0.3.30 its engine stopped as it opened
  • Counting very large tables (GENERATE, CROSSJOIN) no longer runs out of memory: SQLBI's hardware benchmark answers in a fifth of a second

Windows only

  • Import from Power BI: click the model in the list of files open in Power BI Desktop, or choose a .pbip, a Power BI template (.pbit) or a Power Pivot workbook
  • A Power Pivot workbook imports without Excel or Power BI Desktop: its tables, measures and relationships, its data from its sources
  • Tables that do not load can load another way: copied from Power BI Desktop, or read from another server
  • Agents import from Power BI Desktop in one call

Mac only

  • Import from Power BI takes a .pbip, a Power BI template (.pbit) or a Power Pivot workbook, without Excel or Power BI Desktop
  • A Power Pivot workbook's tables, measures and relationships come with it, its data from its sources
  • Tables that do not load can be read from another server

0.3.57

Windows and Mac

  • MINX, MAXX and IF over values of different types answer in the type Power BI gives them: a number where a date meets a decimal
  • A date past the year 9999 shown as text is Power BI's error, as in Power BI Desktop
  • DIVIDE of a blank by zero is blank, as in Power BI

Windows only

  • A studio started by an agent's app (Claude, ChatGPT) opens as an app of its own and no longer holds the agent's connection open
  • If the studio ever fails to start, the reason is written to %LOCALAPPDATA%\OpenBI\Logs\studio-crash.log

Mac only

  • OpenBI Studio for Mac updates itself: a new version downloads in the background and installs on Restart to update, with your Mac's password
  • Help, Update automatically is available on a Mac
  • A studio started by an agent's app (Claude, ChatGPT) opens as a normal app, and the studio already open is used instead of a second one
  • If the studio ever fails to start, the reason is written to ~/Library/Logs/OpenBI/studio-crash.log

0.3.56

Windows and Mac

  • Report pages need about half the memory they did, so one server serves more people at once
  • When memory runs short, the engine cancels only the query that does not fit, with Analysis Services' own message, and keeps serving everyone else
  • The engine stays within the memory its computer, container or OpenBI Server gives it, and openbi limits says which limit it found
  • A SUMX that mixes currencies with decimals or dates adds up every row, as Power BI does
  • A sum of a date column is a date, as in Power BI Desktop

Windows only

  • The bill of materials lists every part of OpenBI itself, and the example projects install without leftover files

Mac only

  • Security: the app runs on the patched .NET 10.0.13, and TikZ pictures render for every user
Also in its notes, from earlier releases (1)
  • The example projects, the bill of materials and the third-party notices now come with the Mac app Mac only

0.3.55

Windows and Mac

  • Long tables fetch their rows as you scroll, as Power BI's do, and a scatter asks only for the points it can plot
  • Report pages answer with about a third of the memory they took, and stay quick when many people open them at once
  • A sum over very small or very large numbers gives the same answer however many cores compute it, as Power BI does
  • A sorted query reads a column before a measure of the same name, as Power BI Desktop does
  • Your data snapshot is never replaced by empty tables when its sources can't be reached, such as a closed Power BI Desktop
  • A project opens from its snapshot however its folder's path is written

Mac only

  • The engine keeps answering when a page closes while its answer is being sent
  • The example projects, the bill of materials and the third-party notices now come with the Mac app

0.3.54

Windows and Mac

  • Slides keep your what-ifs, and Offline lab saves a page whose sliders still move the numbers without OpenBI
  • Operations research: review a plan as a report page before you approve it, with its shadow prices and how far they hold
  • Predictions report their metrics on a held-out test, and the loss chart shows training and validation
  • A prediction's scores are related to who is scored, one-to-one, so your measures use them at once
  • New example, Churn done properly, and notebook methods for calibration, drift, uplift, power and robust plans that your agent finds by goal
  • RELATED works across one-to-one relationships, and column names resolve as in Power BI Desktop
  • Plan review pages stay on your computer when you publish or share, unless you choose one

Windows only

  • The Excel pane keeps its buttons on one line and shows filters by their field names

Mac only

  • Letters with an accent over a capital (Å, Ä, É) are drawn whole again

0.3.53

Windows and Mac

The first release with notes for Mac

  • Server timings show an engine under a gigabyte in MB (it said 0.0 GB)

Windows only

  • OpenBI for Excel: Connect Excel opens an OpenBI pane in Excel - tables, pivots and =OPENBI formulas from your model
  • Faster answers: grouping by two or more columns finds its rows directly (month by product type in two-thirds the time)

Mac only

  • Analyze in Excel works on a Mac: an OpenBI pane in Excel inserts tables, pivots and =OPENBI formulas from your model
  • The engine is tuned for Apple silicon (NEON, the performance cores, a profile-guided build): queries in about 40% less time

0.3.52

Windows

  • Scatter charts draw fit lines: linear, quadratic, polynomial, log, exp and power, with confidence and prediction bands
  • A report edited in OpenBI Server's browser comes back: a bar says who changed it, and Pull pages takes it in (yours saved first)
  • A SQL Server on this computer is trusted by any of its names: a Power BI project's alias, the computer's own name
  • A live connection's culture follows your Windows region (it was Norwegian for everyone)
Also in its notes, from earlier releases (3)
  • Power BI projects that read SQL Server through Sql.Databases load, as Power BI writes it when no database is named
  • The formula bar knows the columns of OpenBI's analytics functions: MAXX ( KMEANS ( ... ), [Cluster] ) no longer warns
  • Right-click OpenBI Studio on the taskbar for your recent projects, as Power BI and Excel show theirs

0.3.51

Windows

  • The formula bar knows the columns of OpenBI's analytics functions: MAXX ( KMEANS ( ... ), [Cluster] ) no longer warns
  • Power BI projects that read SQL Server through Sql.Databases load, as Power BI writes it when no database is named
  • SURVIVAL.LIFETABLE no longer returns an empty, nameless column
Also in its notes, from earlier releases (3)
  • Right-click OpenBI Studio on the taskbar for your recent projects, as Power BI and Excel show theirs
  • A measure's name may hold parentheses in the formula bar, as in Power BI: Sales (LY) = ...
  • Click the engine in the status bar to copy its address (localhost:port), as in DAX Studio

0.3.50

Windows

  • Right-click OpenBI Studio on the taskbar for your recent projects, as Power BI and Excel show theirs
Also in its notes, from earlier releases (2)
  • A measure's name may hold parentheses in the formula bar, as in Power BI: Sales (LY) = ...
  • Click the engine in the status bar to copy its address (localhost:port), as in DAX Studio

0.3.49

Windows

  • A measure's name may hold parentheses in the formula bar, as in Power BI: Sales (LY) = ...
  • Click the engine in the status bar to copy its address (localhost:port), as in DAX Studio

0.3.48

Windows

  • Survival diagnostics and other analytics visuals fit their card on pages without a canvas
  • A chart's format shows on its labels and value axes, also for DAX query values; scatter axes keep the decimals they need
  • Tables from a DAX query keep its order, and heat and bars colour their columns
  • A custom visual taller than its card scrolls inside it
  • Showing a visual as another kind keeps its place, title and colours
  • A new project's culture is your Windows region; change it in the Model view (Culture), or an agent with model_set
  • Agents get DAX timings condensed: repeated requests as one line with a count

0.3.47

Windows

  • Going back to a page with routes, a schedule, clusters, an elbow chart or a UMAP map shows it at once instead of computing it again
  • A schedule shows the same plan each time you come back to it
  • The taskbar pin and the Start menu shortcut keep OpenBI's icon after an update

0.3.46

Windows

  • Publish to OpenBI Server: sign in in your browser, choose a workspace, and the project goes there as a new version (the earlier ones are kept)
  • Publish shows only the step you are on; the steps done fold to one line you can change
  • Before anything leaves your computer, Publish says where it goes and whether its data goes with it
  • Agents can list your workspaces (server_workspaces) and publish when you ask them to (project_publish)

0.3.45

Windows

  • A live Power BI project made on another computer signs in as it opens, instead of showing empty tables
  • Charts name every category; a table's total no longer hides its last row; top="15" shows 15; an empty chart says why
Also in its notes, from earlier releases (6)
  • Live Power BI and Fabric models stay signed in: the sign-in is renewed before it runs out, and quietly if it lapsed
  • Power BI's errors read plainly, with the line and column of a DAX mistake, and show at once, not a minute later
  • Maps of Norway's counties as they were in each period and its municipalities, and of Sweden, Denmark, Finland and Iceland
  • Correlations and DAX in DuckDB (dax()) work on live models
  • Agents: each check starts from the page as it opens, and the report reference comes in sections
  • A project opened from inside a zip file is extracted beside the zip and opened

0.3.44

Windows

  • Power BI's errors read plainly, with the line and column of a DAX mistake, and show at once, not a minute later
  • Correlations and DAX in DuckDB (dax()) work on live models
  • A project opened from inside a zip file is extracted beside the zip and opened
Also in its notes, from earlier releases (5)
  • Live Power BI and Fabric models stay signed in: the sign-in is renewed before it runs out, and quietly if it lapsed
  • Maps of Norway's counties as they were in each period and its municipalities, and of Sweden, Denmark, Finland and Iceland
  • Charts name every category; a table's total no longer hides its last row; top="15" shows exactly 15
  • An empty chart says why: every value blank, or no rows under its filters
  • Agents: each check starts from the page as it opens, and the report reference comes in sections

0.3.43

Windows

  • Live Power BI and Fabric models stay signed in: the sign-in is renewed before it runs out, and quietly if it lapsed
  • Power BI's errors read plainly, with the line and column of a DAX mistake; the technical details folded away
  • A visual whose measure fails on Power BI or Azure says so at once, not a minute later
  • Maps of Norway's counties as they were in each period and its municipalities, and of Sweden, Denmark, Finland and Iceland
  • Charts name every category; a table's total no longer hides its last row; top="15" shows exactly 15
  • An empty chart says why: every value blank, or no rows under its filters
  • Correlations work on live models; DAX in DuckDB (dax()) works on live models too
  • Agents: each check starts from the page as it opens, and the report reference comes in sections

0.3.42

Windows

  • The Data pane shows measures and columns in their display folders, as Power BI does (subfolders and all)
  • Live models: the server's measures and your own kept apart in the Data pane; your folders shown as you made them
  • Agents put new measures in folders named for why they exist, and can sort many measures into folders at once
  • Survival charts: the numbers at risk no longer overlap the group names, and are colored by group
  • Survival charts: medians, means and hazard ratios in a small table under the chart, in the chart's box
  • The page's own canvas can no longer be resized by a drag, which could leave a page drawn at the wrong scale

0.3.41

Windows

  • Connect the Claude app in one click (Agent window): no keys or ports to copy, and the studio opens when Claude needs it
  • Claude Code connects in one click too; any MCP client can start OpenBI Studio as a stdio server (OpenBI.Studio.exe --mcp)
  • Live models keep OpenBI's own results (survival models, networks …) with the server's answers: a page seen again shows at once
  • Survival models are fitted once a page: its visuals and numbers share the fit
  • A visual's DAX in the Visuals pane and the DAX window: colors, autocomplete, parameter hints and errors underlined as you type
  • A visual's query is checked against the model as you type: a wrong name is underlined where it is

0.3.40

Windows

  • The formula bar: click a measure or calculated column to edit its DAX, with autocomplete, parameter hints and errors underlined as you type
  • Measure tools and Column tools: name, home table, format, folder and visibility on the ribbon; a rename updates the DAX and pages that use it
  • Under the formula bar: the measure's value as you type, what it uses and what uses it, and its DAX in earlier versions
  • Copy, cut and paste visuals (Ctrl+C, Ctrl+X, Ctrl+V): on the same page, another page, or another project
  • Ask your agent to improve "this measure": its proposal appears in the formula bar for you to save
  • Share the model: one file to send a colleague, without your own notes and documentation, with or without its data
  • A shared model (.openbimodel) opens with a double-click, as a project of your own
  • Publish: a first look at OpenBI Server, coming in the Beta

0.3.39

Windows

  • The DAX tab's Query plan: each step of a query as it ran, drawn as SQL Server draws plans - its time, runs, rows and how it ran
  • Zoom the plan with the mouse wheel and drag it with the right button; a step clicked shows its DAX
  • Benchmark: a query run five times, each run's time and where it went, then the fastest, median and slowest
  • A live model's benchmark asks its server each time (cold), then uses OpenBI's kept answers (warm)
  • Agents compare a rewrite of a measure with the original (same results, both timed) and show you the plan's slowest step

0.3.38

Windows

  • The report toolbar's Design, HTML, Gridlines and Edit interactions work with Windows Voice Access and screen readers
  • The page's HTML wraps its long lines (Wrap, beside Save), so a visual's whole tag is in sight
  • Opening the HTML shows the selected visual's tag
  • Your agent can show you a report page as you need it: Design on or off, its HTML, the panes, a visual selected

0.3.37

Windows

  • A visual's menu, Show DAX and What filters this? close with Escape or a click anywhere else
  • Download CSV, Excel and typeset PDF save the file where you choose
  • Data over 10,000 rows saves as Parquet instead of CSV, with a note saying so
  • A played scatter chart's menu works again
  • The ribbon is as compact as Power BI Desktop's
  • An adjusted survival chart's tooltip shows the shared number at risk once, not as each group's own

0.3.36

Windows

  • DAX answers checked against Power BI Desktop and SSAS on over 12,000 queries: hundreds of differences fixed in math, text, dates, finance, filters and relationships
  • Ranking and index numbers much faster: RANKX, ROWNUMBER, RANK and FILTER inside iterations, often faster than Power BI Desktop
  • SUMMARIZECOLUMNS keeps only the combinations that exist across its filters, and ROLLUPADDISSUBTOTAL totals filter as in Power BI
  • ALLSELECTED inside iterations, ALLCROSSFILTERED and one-way CROSSFILTER behave as in Power BI
  • Text functions match and case text as Power BI does; COUNTBLANK counts empty texts
  • New: the samples Power BI's line and scatter charts ask for (SAMPLEAXISWITHLOCALMINMAX, SAMPLECARTESIANPOINTSBYCOVER)
  • Fixes for engine crashes with DEFINE TABLE and with some repeated queries

0.3.35

Windows

  • Updates as VS Code does: the studio says it is updating while the new version downloads, then Restart to update, or it updates when you close it
  • Help, Meet my creator: a fuller bio, and why OpenBI

0.3.34

Windows

  • Open a project from File Explorer: double-click its .openbi file, or right-click a folder or a page and choose Open in OpenBI Studio
  • The Data pane ticks what the selected visual uses, as Power BI does: a green check on its tables, its fields ticked
  • On canvas pages Expand fills the window, and Show DAX opens over the visual instead of over its chart
  • Survival: how each Cox effect changes over time, as R's cox.zph plot - the residuals, the smooth and its band
  • Reference lines from DAX, and vertical ones (x-marks): a date, a value, the lasso's lambda.min and lambda.1se
  • Band charts that cross zero draw the band from its lower bound
  • Help, Meet my creator: who made OpenBI, and where to send inquiries
  • Server timings name a live model as it is called, not by its address

0.3.33

Windows

  • Visual calculations as in Power BI: PREVIOUS, RUNNINGSUM, MOVINGAVERAGE, LOOKUP and the rest, over a visual's rows and columns
  • The DAX tab's Server timings: each storage engine request with its CPU, and the computer it ran on (memory, CPU, instruction sets)
  • The DAX tab's Model analyzer: what makes a model big, table by table and column by column, also for live servers; .vpax in and out
  • A matrix no longer works out its empty cells: SQLBI's visual-calculations page now as fast as Power BI Desktop
  • Faster sums over many rows (a quantity times a price), distinct counts, time intelligence and subtotals
  • Currency arithmetic as in Power BI: an amount times or divided by a number stays a currency of four decimals
  • SUMMARIZE's added columns read the columns they group by, as in Power BI
  • An unexpected error shows what went wrong instead of "Exception has been thrown by the target of an invocation"

0.3.32

Windows

  • Live reports spare a shared capacity: the server's answers are kept 24 hours and dropped when its data is refreshed (Power BI Desktop on this computer: always asked)
  • The same query on its way goes to the server once, at most four at a time, each with an id its logs show; a page's cards are asked in one query
  • A query the server takes longer than 225 seconds on is stopped there, and so is one no page waits for any more (a page closed or filtered anew)
  • The pages' gallery shows the answers already kept: opening it asks the server nothing
  • A query that needs more memory than the computer can give stops with an error instead of slowing everything down
  • Survival analysis (survival curves, hazard, Cox regression with start/stop rows), PCA, k-means and UMAP, with their visuals
  • Retention predictions with LightGBM, and the lasso and elastic net with lambda chosen by cross-validation
  • NOT binds below comparisons as in Analysis Services; renamed columns in Power Query keep their data

0.3.31

Windows

  • A live connection's kept server answers outlive closing the studio and changing a measure: pages and forecasts open at once
  • Server results and the other menus show a check on the current choice
  • World maps find France and Norway by their ISO codes (and key="ISO_A2_EH")
  • Slides save where you ask (a folder in the project too), also when an agent asks for two at once
  • A page's picture is always of the page asked for; notes stay inside a chart on phones
  • Column groups (bands) find a heading written in quotes

0.3.30

Windows

  • Matrices sort by a value: click its heading (largest first, then smallest), under a column too
  • Slicers keep one selection across the report's pages (sync), and dropdowns have a search inside
  • Tables and matrices to Excel, or as an Outlook draft with the workbook attached; a button can do either
  • Headings with tooltips, alignment and grouped headings; presets show checks and coloured changes
  • Matrices highlight the branch you work on; a summary table lines up with its detail
  • Edit interactions as in Power BI: a visual can ignore selections and says so; "What filters this?" in every menu
  • Agents see and act on a page (choose, check, export), and everything done is kept in an activity log

0.3.29

Windows

  • Design mode: a matrix's +/- and drill buttons, and a table's search, work while you design, as in Power BI
  • Tables and matrices: choose their font and font size
  • Figures in matrices and long tables are no longer cut short

0.3.28

Windows

  • Matrices drill as Power BI's: drill up, drill down into a row, the next level, expand all one level
  • Long tables and matrices scroll: rows come as you scroll, no "Show more"
  • Search in tables, as DataTables: the rows found as you type, the words marked, their total
  • Tables and matrices in R's kableExtra looks: paper, classic, minimal, material (striped, condensed)
  • Print a table or a matrix as a typeset PDF in its look, or copy it as LaTeX
  • Faster sorting and searching of text in the engine

0.3.27

Windows

  • DAX formatted as DAX Formatter lays it out, on your computer: Format, or Ctrl+Shift+F
  • A visual's DAX opens in a larger, formatted editor; new measures are formatted when added
  • Ask the agent to format your measures and describe them
  • An image's dominant colours in DAX (IMAGECOLORS, IMAGECOLOR, COLORNAME) and in M (Image.Colors)
  • Model view: move tables anywhere, widen tables and the side panes
  • The ribbon's tabs change with the mouse wheel

0.3.26

Windows

  • Help: OpenBI's and Querex's marks, and Meet my creator, large enough to see
Also in its notes, from earlier releases (5)
  • Slides keep their size on wide screens, readable as designed; Fit (Z) fills the window
  • Clicking is optional: Auto (A) brings each slide's visuals in by themselves
  • PowerPoint: a page taller than a slide continues on the next slides, each marked "continued"
  • Saving a PDF asks: 16:9 slides to show, paper (A4 or Letter) to print, or whole pages
  • PDFs of the slides no longer show the designer's dashed box on every page

0.3.25

Windows

  • Slides keep their size on wide screens, readable as designed; Fit (Z) fills the window
  • Clicking is optional: Auto (A) brings each slide's visuals in by themselves
  • PowerPoint: a page taller than a slide continues on the next slides, each marked "continued"
  • Saving a PDF asks: 16:9 slides to show, paper (A4 or Letter) to print, or whole pages
  • PDFs of the slides no longer show the designer's dashed box on every page
  • Help: OpenBI's and Querex's marks, and Meet my creator

0.3.24

Windows

  • Present: the report's pages as slides in your browser, a visual per click, the data live (step= on a visual sets its click)
  • Slides: the report saved as one small HTML file that plays anywhere, each visual coming in on its click, animated
  • Slides as a PDF (a page per slide, its text sharp and searchable) or a PowerPoint (each step's visuals fading in)
  • The HTML slides print a page per slide and record themselves as a video
  • Slicers show the values the other filters leave, as Power BI's; a selection left without rows is shown apart
  • A dax= visual's own conditions apply with the page's filters
  • A page whose own script fails now fails the agent's check
  • Maps say how much of the value they could not place

0.3.23

Windows

  • Live models: when the server's model renames or removes a measure, only the visuals using it stop, naming the server and model
  • Differences from the server: the status bar shows what a live project has differently, in red when server changes broke something
  • Renaming a server's measure here asks first: ideally the model's owner renames it on the server, for everyone
  • Canvas pages keep their size on wide screens, centred, as Power BI's (fit="width" stretches them)
  • {{filters}} in a page's DAX queries brings the page's and the report's conditions too
  • Error messages can be selected and copied, to paste to the agent
  • SHAP charts: hover a dot to see its row, the feature's value and its effect
  • Help, Consulting: Querex, the premier partner for specialty plug-ins, OpenBI SDK questions and MCP development

0.3.22

Windows

  • PREDICT works on live connections: forecasts on a live model's pages, and Use in model makes such a page
  • Live models: set a server column's format, folder, sort by, description and visibility; rename a server measure
  • A matrix with rows only opens level by level, each group with its subtotal (expand="2" or "all" opens more)
  • Slicer defaults relative to the data: default="latest", "previous" or "latest complete"
  • Phones: canvas pages stack with slicers, cards and text at their own height; scatter points can show their names
  • Forecasts choose their trees on months of their own, so the likely range holds; Norway's calendar and outside series as inputs
  • Notebooks: a LightGBM error no longer ends the kernel for good; cross-validation over time folds; Table.FromRecords
  • SHAP charts in notebooks (Chart.Shap, ShapDependence, ShapWaterfall); each prediction's notebook shows the beeswarm

0.3.21

Windows

  • A waterfall with top keeps the biggest steps up or down and adds the rest as Other, so its total is right
  • Charts: top-by="abs" keeps the biggest gains and losses; notes can name their series (Rødvin|Nov: ...)
  • Colors by name: colors="Hvitvin: #c08a3e, Rødvin: #7b1e2b"
  • Tables sort by several columns or measures, also measures not shown; tied rows keep their order
  • {{filters}} in a query works after a comma of its own too
  • Forecasts on month-start dates no longer treat the latest complete month as in progress

0.3.20

Windows

  • Live connections over HTTPS keep the server's answers 24 hours (was 10 minutes); Refresh still asks afresh
  • Server results has a new choice: kept 24 hours
  • Time series decomposition and Monte Carlo visuals work on live connections again (they failed now and then)

0.3.19

Windows

  • Live connections over HTTPS are quicker: a report page you have seen opens at once instead of asking the server again
  • Choose how long the server's answers are kept: Home, Queries, Server results (not kept, minutes, an hour, until Refresh)
  • Refresh and the page's reload always ask the server afresh; new or changed visuals always do
  • Analyze in Excel works again, for imported and live models

0.3.18

Windows

  • Query dependencies in Transform data (View), as in Power Query: each data source, the queries that read it, and the queries and parameters they use
  • Each query shows whether it is loaded, not loaded, a parameter or a function
  • Turn the picture top to bottom or left to right, zoom and fit; click a box to see what it uses and what uses it
  • Passwords and keys in connection strings and addresses are never shown

0.3.17

Windows

  • Power BI projects: opening one asks whether to keep it working in Power BI or make it an OpenBI project
  • Kept working in Power BI, it still opens in Power BI Desktop after your changes - data source settings stay on this computer
  • Power BI projects load at once: OpenBI reads the servers their queries name, signed in with this computer's credentials
  • A project an earlier version changed so Power BI could not open it is put right when you open it
  • Blank rows as in Power BI: keys missing from a table through an inactive relationship show under (Blank)
  • Processed data stays out of your project's versions, and Power BI's files keep their line endings

0.3.16

Windows

  • Specialty modules: turn them on under Specialty in the navigation - the first is Customer Service
  • Customer Service: answer a mailbox (Microsoft 365, Outlook.com, Gmail, iCloud or any IMAP) with an agent and your data, step by step; nothing is sent without you
  • Personal data stays private: the agent sees names, addresses and identity numbers as tokens (OpenBI's own detection, or Microsoft Presidio)
  • Anonymize in Transform data: replace, mask or hash personal data in a column (Privacy.Anonymize in M)
  • Tabs in windows of their own: the report on one screen, Customer Service on another, a notebook on a third (View, New window)
  • Transform data: a click on a query selects it wherever on its row; the queries listed as compactly as Power Query lists them
  • Greyed tabs say why when you point at them

0.3.15

Windows

  • Refresh shows each table's progress, as Power BI does, and which table failed and why; Cancel stops it
  • Updates download in the background: Restart to update installs them (from this version on)
  • New sources: Web API, OData, SharePoint Online lists, Exchange Online, Dataverse and Azure Data Explorer
  • More sources: Salesforce objects and reports, Google Analytics, ODBC, Amazon Athena, Active Directory and Bloomberg (BQL through your Terminal)
  • OneLake catalog and AWS catalog: the data of Fabric and of AWS you can open, listed as Power BI's OneLake catalog lists it
  • Python and R scripts as sources, once you allow scripts for the project
  • Labels at the ends of lines in each line's color (change on last year), and a scrollbar under the page tabs
  • Notebook cells show how long they ran; the transform editor's applied steps are compact, as in Power Query

0.3.14

Windows

  • Undo and redo in the report, as in Power BI: Ctrl+Z and Ctrl+Y, or the buttons beside the project's name
  • Undo takes back any change to the report: visuals moved, sized or formatted, filters, the theme, pages added, deleted or renamed
Also in its notes, from earlier releases (3)
  • Drag a visual anywhere on any page: a page with a layout of its own becomes a free canvas, as in Power BI, everything kept where it is
  • Each visual is its own box: the boxes around visuals go, so a visual's size is the size you give it
  • A click in the empty part of the box around a visual selects the visual

0.3.13

Windows

  • Drag a visual anywhere on any page: a page with a layout of its own becomes a free canvas, as in Power BI, everything kept where it is
  • Each visual is its own box: the boxes around visuals go, so a visual's size is the size you give it
  • A click in the empty part of the box around a visual selects the visual

0.3.12

Windows

  • Free-form canvas pages as in Power BI: drag visuals anywhere, snapping to the grid and to each other; the page scales as a whole
  • Design and View tabs: themes, page size, background and wallpaper, gridlines, page views, Selection and Performance panes
  • Filters with greater than, less than or DAX, lists that narrow as you type, % of total and number formats on any value
  • New charts: a play axis (Rosling's moving bubbles), small multiples, densities of several variables, years on month axes
  • Notebooks show report visuals and print as a paper beside the steps: sections, numbered figures and tables, code in an appendix
  • TikZ steps in notebooks: figures drawn as papers draw them (TikZ, pgfplots, tikz-cd, circuitikz), compiled offline
  • Easier to reach: a pane's whole header folds it, page tabs scroll with arrows, the mouse wheel scrolls a notebook anywhere

About these notes

Each release carries at most eight short lines: the ones its update bar showed. A line can stay in later releases’ notes until newer lines take its place, so it is listed under the release that first carried it, and folded under “Also in its notes” in the releases after.

Mac notes begin with 0.3.53, when the Mac and Windows studios took one version number; earlier releases list Windows notes only. Where the two differ, each has its own column.

OpenBI Server’s changes are not listed here.