A small set of ready-made Power BI queries for open Norwegian data sources – chosen because they solve concrete finance and reporting tasks. Copy the M-code, paste into Power Query, done.
Each query is built for one concrete task – and can be configured in the browser before you copy the code.
Paste the organisation numbers of your customers or suppliers and get one table flagging bankruptcy, forced dissolution, liquidation and deletion – with current name, address, industry and employee count. Spot the risk before the invoice goes out, on every refresh.
Daily rates from Norges Bank, shaped for accounting: weekends and holidays are filled with the last quoted rate, and currencies quoted per 100 (SEK, DKK, JPY) are converted to NOK per unit. Join straight on transaction date and convert to NOK with no blank rows.
The spot price for your price area hour by hour, in øre per kWh both excluding and including VAT – including tomorrow's prices once published. Join with your own consumption to see what power actually costs, and when shifting load pays off.
The consumer price index month by month with a ready-made adjustment factor from the base month you choose. Multiply the amount by the factor to get the correctly adjusted rent, lease or contract price – updated automatically when Statistics Norway publishes new figures.
The date table every Power BI model needs, in Norwegian: year, quarter, month, ISO week and weekday – plus all Norwegian public holidays and a ready-made working-day flag, so you can calculate revenue per working day with nothing to maintain.
Look up one company by organisation number and get name, status, address, industry, employee count and VAT registration as a ready-made row. A quick taste of how the queries work.
An M-code query is a ready-made recipe that tells Power BI exactly how to fetch, clean, and shape data from an API — without you needing to write a single line of code yourself.
We've done the hard work — so you don't have to.
Real M-code, ready to use. Paste into Power Query and run.
let
Source = (OrgNr as text) =>
Json.Document(Web.Contents(
"https://data.brreg.no/enhetsregisteret"
& "/api/enheter/" & OrgNr
)),
Resultat = Source("923609016")
in
Resultat2 queries free. No credit card.