Releases

The versions these docs describe, what each one works with, and where to find every release’s full notes.

The current versions

Every page in these docs ends with the version it describes. Each installer’s signature check is on its install page: Install OpenBI Studio, Install on Windows, Install on a Mac and the gateway’s.

What’s new

OpenBI Studio 0.3.79

Released 9 November 2026.

• Claude no longer opens OpenBI Studio by itself. The connector an agent’s app starts with each of its sessions (OpenBI.Studio.exe --mcp) answers the session’s setup and its list of tools itself, and starts the studio, or attaches to the one that is open, only when the agent uses one of its tools. A studio you closed stays closed until then. See The connector.
• M checked against Power BI Desktop: 67 suspected differences were checked one by one against Power BI Desktop 2.159, and corrected wherever Desktop answered otherwise, but for the known differences below:
  • cultures: numbers, dates and times written and read as Desktop does in each of 915 cultures (Number.ToText, Text.From, Date.ToText, the FromText functions, month and day names);
  • Turkish and Polish capitals, and every other letter: Text.Upper, Text.Lower and Text.Proper case text as Desktop does;
  • text encodings: 95 code pages and byte order marks, and a character for bytes that aren’t text, as Desktop;
  • random numbers and GUIDs are new in every run (0.3.78 gave the same sequence each time), and List.Random with a seed gives Desktop’s numbers;
  • numbers, records, lists and tables: rounding, Number.Factorial, List.Median, List.Union and List.Intersect, MissingField.Ignore and MissingField.UseNull, Table.Schema and more, and 14 functions OpenBI didn’t have (Value.Add, Number.Combinations, Time.StartOfHour …);
  • Excel dates read as Desktop reads them, also in a header row promoted to column names;
  • Sql.Database navigates by schema as Desktop does, and OData.Feed sends the headers you give it;
  • Exchange.Contents: mail, calendars with their sub-calendars, meeting requests and their cancellations, in this computer’s local time, as Desktop gives them. Known issue: Tasks needs a permission to Microsoft To Do that the sign-in doesn’t have yet, so it can’t be read.
• The Locale for import, Power BI Desktop’s setting of the same name: Transform data reads and writes text, numbers and dates in the project’s locale for import, else the model’s culture, else en-US, as Desktop does. Set it in the Model view, with nothing selected; a new project takes it from the computer’s region. Get data’s steps name no culture, Using locale… changes a type with a locale of its own, and filters are those of the column’s type. See Culture and Locale for import and Types, filters and the locale.
• The refresh bar once after the upgrade: a table whose query uses an M function 0.3.79 corrected shows the stale-data bar under the ribbon once, as its data is still what the earlier version read. Refresh reads it again and clears the bar. Nothing is read again by itself.
• Every function in the formula bar’s hints: the signatures of all 482 OAX functions, OpenBI’s own included. The docs have a page for every M function (see M functions) and 8 new OAX pages: SKEW.S, SKEW.P, SKEWX.S, SKEWX.P, KURT.S, KURT.P, KURTX.S and KURTX.P.

Known differences in 0.3.79

15 differences from Power BI Desktop remain in M. Each is said on its function’s page, under Compared with Power Query, with Desktop’s answer and OpenBI’s:

• Very large whole numbers: Text.From of a number of more than 15 or 16 digits written in a query, and Number.ToText of a computed number from 10¹⁵ with a format. OpenBI holds every number as a double, exact to 15 or 16 digits.
• Sorting by a culture’s alphabet: Comparer.FromCulture orders by character code (by design: so does OpenBI everywhere).
• The same random value in every row: in a column added with Table.AddColumn, Desktop gives every row the same Number.Random, List.Random or Text.NewGuid; OpenBI gives each row its own.
• Bytes read at once: #binary and Binary.FromList read their list at once, so try catches a wrong byte where Desktop finds it later.
• Characters beyond the basic range (emoji, some scripts) are kept whole by Text.Start and Text.ToList, where Desktop can cut them in two halves.
• Code pages: Text.FromBinary reads only the plain ASCII text of code pages that take several bytes for a character (Shift-JIS and others), and Text.ToBinary turns a letter a code page lacks into its nearest plain letter in code page 1252 only.
• Calendars: Date.ToText in a culture of the Persian or the Hijri calendar (fa-IR, ar-SA) raises an error that says so.
• A time zone written as text: DateTimeZone.FromText keeps the offset a text names (“GMT”), where Desktop takes the computer’s.
• A day and month without a year in fi-FI: Date.From reads “5. maaliskuuta” as 5 March of this year, where Desktop gives an error.

OpenBI Server 0.1.50

Released 9 November 2026.

• Its engine is OpenBI Studio 0.3.79’s: M answers as Power BI Desktop’s in the cases above, and M’s culture is the model’s locale for import, else its culture, else en-US.
• A note on models to refresh once: a published model whose data was computed with an M function 0.3.79 corrected says so on its settings page, to the workspace’s Admins and Members, with Refresh now where the server reaches its sources (otherwise, refresh it in OpenBI Studio and publish it again). Until then its reports show the data as it was published. See To 0.1.50.
• Buying OpenBI Server: one seat is “1 seat” on the buy page and in every e-mail, and the page after a purchase names the sender of the confirmation, Querex AS <faktura@querex.no>, and says to look in the junk or spam folder. See Buy OpenBI Server.
• No change to the server’s records, and no one-time step.

OpenBI Gateway 0.1.50

Released with OpenBI Server 0.1.50, with the same engine, so models it refreshes give the same answers as on the server and in OpenBI Studio 0.3.79.

OpenBI Studio 0.3.78

Released 7 November 2026.

• New: NETWORK.ROLLUP multiplies the weights along every path from a set of starts and adds the paths up: a forecast exploded into the parts it needs, costs rolled up into products, what an owner really holds through chains of companies, support costs allocated back and forth, input-output tables. A loop is refused, and named, or solved exactly. Its answers are checked against Statistics Norway’s and Statistics Finland’s published input-output tables. In notebooks, Graph.Rollup gives the same answers (see Networks).
• Network functions read their rows about 10 times faster, with the same answers.
• The query plan shows each network function’s own steps: reading the rows, numbering the nodes, the graph work and building the result, each with its time, rows and a note. See A network function’s own steps.
• Matrices fit their card: their headings wrap between words, and a matrix wider than its card scrolls inside it, never the page. See Tables, matrices and statements.
• A visual’s own query can keep every filter of the page but one column’s, with {{filters except 'Table'[Column]}}, and read that column’s selection, with {{values 'Table'[Column]}}. See A visual with a query of its own.
• Slicers on the same table no longer leave each other blank.
• The agents’ report_edit removes an attribute set to null.
• A page measure defined the same on several pages is pointed out when an agent writes or checks a page, and measure_set with from_page makes it one of the project’s own measures, taking its copies off the pages. See The agent’s hands.
• A server that moved to a new name (OpenBI Server 0.1.49’s Change domain) is followed: the studio says the move in plain words, Publish goes to the new address from then on, and you sign in there once. See Change domain.

OpenBI Server 0.1.49

• Buy OpenBI Server on your own server, from Querex AS, OpenBI Server’s distribution partner: one public price, 12 kr + MVA per seat per month, monthly or yearly, with a 30-day free trial for 1 to 5 seats. The setup page buys it and the server activates its licence by itself; the Admin portal’s Billing adds and removes seats, switches the plan, cancels and resumes, and opens Stripe’s page for the card and invoices. Buy at querex.no leads to the seller’s own site through a page of your server. See Buy OpenBI Server.
• Seats: a server with a seat licence counts the people who can sign in, and stops new ones when every seat is taken; nobody already in is cut off. Only the number goes to the seller. A licence from before seats works as before. See Seats.
• Import people from a CSV or Excel file, with their workspaces and roles, invited at the mailbox’s pace. See Import people from a file.
• Your server’s web address: type or paste what people open, such as https://bi.norwayanalytics.no/, and the licence is for its domain. Without a domain, a made-up one under home.arpa, with HTTPS from the server’s own certificate authority (https local). See No domain yet: a made-up one.
• Change domain, with a transition period in which the old addresses redirect to the new ones. OpenBI Studio 0.3.78 and OpenBI Gateway 0.1.49 follow the server to its new name. See Change domain.
• Its engine is OpenBI Studio 0.3.78’s, with NETWORK.ROLLUP and network functions that read their rows about 10 times faster.
• The records gain the seats’ tables as 0.1.49 first starts; there is no one-time step. See To 0.1.49.

OpenBI Gateway 0.1.49

Released with OpenBI Server 0.1.49, with the same engine, so models it refreshes give the same answers as on the server. A member follows its server to a new domain by itself, and keeps the new address. See When your server moves to a new name.

OpenBI Studio 0.3.77

Released 6 November 2026.

• Network functions give the same answer whatever order the rows come in: the nodes are numbered by their values, no longer by the order the rows arrived. This changes some answers once against 0.3.76: a few communities, the order of the rows, ties, drawings and SIR runs. See Open Graph.
• New network functions: NETWORK.RINGS (groups held together by triangles, such as fraud rings), NETWORK.WEAKPOINTS (the nodes and links whose loss splits a network), NETWORK.CUTS (the weakest cuts by capacity) and NETWORK.PREDICT (the links most likely missing); NETWORK.SIMILARITY can keep only the most similar pairs.
• Notebooks use Open Graph: a Graph from the model’s rows, with communities, paths, flows, embeddings and spreading, and every Open Graph function. See In notebooks.
• Leiden finds communities about twice as fast on Macs, and fast greedy’s communities on large networks come much closer to the reference groupings.
• Paste page and pasting visuals wait a moment while another program holds the clipboard, and say so if it stays busy.

OpenBI Server 0.1.48

• Its engine is OpenBI Studio 0.3.77’s: a server answers as those studios do, with the nodes of a network numbered by their values and the new network functions. No change to the server’s records.

OpenBI Gateway 0.1.48

Released with OpenBI Server 0.1.48, with the same engine, so models it refreshes give the same answers as on the server.

OpenBI Studio 0.3.76

• Networks measured with Open Graph, Norway Analytics’ own graph library, built into the engine: in notebooks, the NETWORK.* functions and the <obi-network> visual. It is API-compatible with igraph 1.0’s C interface, and its answers are checked against python-igraph’s. Most answers are the same as 0.3.75’s; a drawing’s positions (NETWORK.LAYOUT), the communities Infomap and fast greedy find, and the route of a maximum flow can differ. Louvain, Leiden, label propagation and Walktrap give the same communities. See Open Graph.
• NETWORK.SENSITIVITY gives exact derivatives for PageRank, eigenvector centrality, strength, closeness and harmonic centrality (betweenness still by small steps of each weight), and judges a request’s time before it runs: one that would take more than about 20 seconds is refused at once, saying how long it would take. Many requests 0.3.75 refused now answer.
• The bill of materials lists Open Graph, Norway Analytics’ own component.

OpenBI Server 0.1.47

• Its engine is OpenBI Studio 0.3.76’s, with networks measured by Open Graph: published reports with network visuals or NETWORK.* measures can show other drawings and, with Infomap or fast greedy, other communities. See Open Graph.
• A lake’s nightly maintenance that fails runs again as its error says: once a night when only an administrator can put it right, otherwise after 1, 5 and 15 minutes and then every hour, for six hours. The lake’s page, the Admin portal’s Lakes and lake list say why and when it runs again. Scheduled lake backups do the same, and only the night’s first failure is e-mailed. See When maintenance fails.
• lake setup-reader works with a PostgreSQL administrator that may create roles but isn’t a superuser: it creates the reader role, and the lake’s writer grants it what it reads. See Who may use a lake.

OpenBI Gateway 0.1.47

Released with OpenBI Server 0.1.47, with the same engine, so models it refreshes give the same answers as on the server.

OpenBI Studio 0.3.75

Released 4 November 2026.

• Fuzzy matching in M: Table.FuzzyJoin, Table.FuzzyNestedJoin, Table.FuzzyGroup and Table.AddFuzzyClusterColumn, with Power BI Desktop’s similarities; a few pairs close to the threshold can differ. See Fuzzy matching.
• New OAX functions: SKEW.S, SKEW.P, KURT.S, KURT.P and their X forms; NETWORK.LINKS, NETWORK.COMPARE, NETWORK.MATCH and NETWORK.SENSITIVITY. See OAX functions.
• PDFs keep what their pages show: links, lists’ numbers and bullets, gradients; margins, a page on one sheet, and page numbers in the footer. See The PDF’s layout.
• Open Query: OpenBI’s query editor and the engine that runs its M are called Open Query; the ribbon’s button is still Transform data. An agent that applies its queries does it as Close & apply, which you see. See Transform data.
• Agents connect through OpenBI.Studio.exe --mcp: as it starts, the studio changes apps connected the old way, with the endpoint’s address and key, to the connector, keeping a backup of each settings file; the endpoint’s address and key are under Advanced. See Connect your agent.
• Azure Storage: AzureStorage.Blobs, AzureStorage.DataLake and AzureStorage.DataLakeContents, with the sign-ins Power BI offers (anonymous, organizational account, account key, shared access signature), and Excel workbooks read from cloud storage or the web.
• Report pages speak all seven languages, a matrix shows a Top N, and percentile marks, month axes, KPI sparklines and mark labels draw as asked.

OpenBI Server 0.1.46

• Its engine is OpenBI Studio 0.3.75’s: fuzzy matching, the new functions and Azure Storage’s functions and sign-ins on the server too.
• MySQL and MariaDB are no longer a records database. A server whose records are there must move them with 0.1.45 first. As a data source, MySQL works as before. See From 0.1.45 or older.
• Clickable links in PDFs: a report’s PDF keeps its links, each over its words, on by default. See Links in a PDF.
• Refreshes a stopped node or server left unfinished are settled by what they did, and a lake load already written is never written twice.
• Cloud storage: with the file guard on (the default), a refresh reads only the buckets and containers its model’s data sources name, with the credentials set for them; and DuckDB’s reads of cloud storage go through the system’s proxy.
• Accepted DuckDB extension findings are kept in the server’s records. On SQL Server or PostgreSQL, accept them again after the upgrade.

OpenBI Gateway 0.1.46

Released with OpenBI Server 0.1.46, with the same engine, so models it refreshes give the same answers as on the server.

OpenBI Studio 0.3.74

Released 3 November 2026.

• Several visuals at once: in Design, Ctrl+click, Ctrl+A or a box drawn on the canvas selects several (Cmd on a Mac); copy, cut, paste, move and delete them together, into another page, another project or another studio window. See Several visuals at once.
• Whole pages between projects: a page tab’s Copy page and Paste page, and Import pages…, bring pages with their page measures, settings and pictures. See Pages from another project.
• Numbers that change: ACCRINT, VDB, ODDFPRICE, ODDFYIELD, HISTOGRAM and LINESTX now give Power BI Desktop’s answers (HISTOGRAM: R’s hist bins), so a report that uses them can show other numbers than with 0.3.73.
• More functions give Power BI Desktop’s answers, among them LOOKUPVALUE and CONTAINS over a related table’s columns, FIRSTNONBLANK over a table, KEEPFILTERS around an iterator’s table, RANDBETWEEN, the PATH functions and ISONORAFTER.
• Refused, as in Power BI Desktop: KEEPFILTERS where Power BI doesn’t take it, and NONVISUAL on a column the query doesn’t group by, now give an error instead of an answer. See Refused, as in Power BI.
• PATH over a parent that is no row’s id keeps its answer, and now warns as the model loads, naming the rows. See Differences kept on purpose.
• Agents copy visuals and pages between projects (report_copy, report_import) and whole projects (project_copy), and a call made just after a project opens waits for its engine. See Copies of pages and projects.
• 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.

OpenBI Server 0.1.45

• Its engine is OpenBI Studio 0.3.74’s: the same answers that change, and the same refusals. A visual whose query uses KEEPFILTERS or NONVISUAL where Power BI Desktop refuses them shows that error.
• Refresh history says when a model’s calculated column uses PATH over a parent that is no row’s id: the refresh succeeds, with a warning naming the first rows, shown to those who refresh the item. See History and the Monitor.
• Sign-in on the server itself: once sign-in is set up, the setup page asks for one too, and licences are the command line’s. A forwarder in front of the server must pass each visitor’s address in X-Forwarded-For, as IIS and the Mac’s front door do. See Sessions and sign-in.
• The bill of materials accepts eleven findings in SQLite 3.53.3 by their ids, each assessed as not reachable as the server ships, until a release ships SQLite 3.54.0 or later. See Accepted findings.
• No change to the server’s records and no one-time step; the data snapshots are as before, so there is nothing to republish, and going back to 0.1.44 is safe. See Upgrade and rollback.

OpenBI Gateway 0.1.45

Released with OpenBI Server 0.1.45, with the same engine, so models it refreshes give the same answers as on the server. The gateway itself works as in 0.1.40, when it arrived.

What works with what

To upgrade a server, its cluster or its gateway, follow Upgrade and rollback. OpenBI Studio says when a newer version is out: see Updates.

Every release’s notes

Every release’s notes are on www.openbi.no/releases/.

Last updated 8 November 2026 · OpenBI Studio 0.3.79, OpenBI Server 0.1.50, OpenBI Gateway 0.1.50