Setting up Microsoft Azure for your dashboard

A step-by-step guide for business owners. About 15 minutes. We're happy to do it together with you on a short call.

About 15 minone-off setup
About ยฃ4โ€“8 / monthAzure running cost for a typical small business
Your accountyou own everything and pay Microsoft directly
Limited accesswe only see one "folder" you choose

๐Ÿ™‹ Prefer we do it for you?

Most clients do. Book a 20-minute set-up call: you only sign in and add the company card, and we do everything else while you watch. No reading needed.

๐Ÿ“… Book the set-up call

Rather do it yourself? Follow the 7 steps below.

Why Azure?

Azure is Microsoft's cloud. It safely stores the tidy version of your business data (sales, stock, jobs) in a small database in London, and updates it automatically every morning. Your Power BI dashboard reads from it. Because it's your account, your data never leaves your control and you can switch our access off at any time.

Before you start

๐Ÿ’ก No Microsoft 365 at work? No problem: in step 1 go to azure.microsoft.com/free instead and sign up with your business email. Everything else is the same.
1

Sign in to Azure

  1. Open portal.azure.com on a computer (it's much easier than a phone).
  2. Sign in with your work Microsoft account โ‘ , then press Next โ‘ก and enter your password and the code from your phone.
Microsoft sign-in screen with the work email field and the Next button highlighted
Simplified illustration: your screen may look slightly different.
2

Start your Azure subscription

  1. On the Azure home page, click Start with an Azure subscription โ‘  (or "Start free").
  2. Fill in your business name and address, verify your phone, and add the company card.
  3. Choose Pay-As-You-Go (you only pay for what's used). If Microsoft offers free credit for the first month, you can accept it.
๐Ÿ’ก If your company already has an Azure subscription, skip this step.
Azure home page with the Start with an Azure subscription button highlighted
Simplified illustration.
3

Set a spending alert (important)

So there are never surprises on the bill:

  1. In the search bar at the top type Cost Management, open it, then Budgets โ†’ + Add.
  2. Name it e.g. monthly-dashboard-budget, period Monthly, amount ยฃ30 โ‘ .
  3. Add your email for the alerts โ‘ก (alerts at 80% and 100%), then Create โ‘ข.
โœ… A typical small-business setup costs about ยฃ4โ€“8 a month, so ยฃ30 gives plenty of headroom. You'll get an email if anything ever gets close.
Create budget form with amount, email and Create highlighted
Simplified illustration.
4

Create a "folder" for the dashboard

Azure calls it a resource group. We'll only work inside this one.

  1. Search Resource groups โ†’ + Create.
  2. Name: rg-data-pipeline โ‘ 
  3. Region: (Europe) UK South โ‘ก (London, keeps your data in the UK)
  4. Review + create โ‘ข โ†’ Create.
Create a resource group form with name, UK South region and Review + create highlighted
Simplified illustration.
5

Invite Red Brick Data as a guest

  1. Search Microsoft Entra ID (this is your company's list of users) โ†’ Users โ†’ + New user โ†’ Invite external user.
  2. Email: [email protected] โ‘ 
  3. Review + invite โ‘ก. We'll accept the email invitation.
๐Ÿ’ก Can't see "Invite external user"? Your account may not have the rights: ask your IT person or Microsoft 365 admin, or book a call and we'll work out who can.
Invite external user form with the email and Review + invite highlighted
Simplified illustration.
6

Give access to that folder only

  1. Open Resource groups โ†’ rg-data-pipeline โ†’ Access control (IAM) โ†’ + Add โ†’ Add role assignment.
  2. Role: Contributor โ‘ . This lets us build the database and the daily update in this folder.
  3. Members: select Red Brick Data โ‘ก โ†’ Review + assign โ‘ข.
โœ… With this, we can't see your billing, your other Microsoft services or your emails, and we can't give access to anyone else.
Add role assignment with Contributor, the member and Review + assign highlighted
Simplified illustration.
7

Power BI (only if you already use it)

If you already have Power BI: open app.powerbi.com โ†’ Workspaces โ†’ create one called e.g. Sales Dashboard โ†’ Manage access โ‘  โ†’ add [email protected] โ‘ก as Member โ‘ข.

Not using Power BI yet? Skip this: we'll set it up together and explain the licences first (Power BI Pro is about ยฃ10.80 per person per month, paid to Microsoft, only for people who view dashboards online).

Power BI workspace Manage access with Add people, email and Member role highlighted
Simplified illustration.

โœ… Done! Let us know

Email [email protected] to say it's done. We'll accept the invitation, check everything works and start building. Please don't send passwords or data files by email: with the access above we don't need them.

๐Ÿ“… Prefer to do it together? Book 30 minutes โœ‰๏ธ Email us

Questions people ask

Is my data safe?

Your data stays in your Microsoft account in Microsoft's London data centre, protected by your company login and two-step security. We only get access to the one folder from step 4, and only for as long as we work together.

Who pays for Azure, and how much?

You pay Microsoft directly, monthly, for what's used. A typical small-business setup (a small database and a daily update) costs about ยฃ4โ€“8 a month. Your ยฃ30 budget alert from step 3 warns you long before anything unexpected. Power BI licences, if needed, are separate (about ยฃ10.80 per viewer per month).

Can I see what it costs at any time?

Yes: Azure portal โ†’ Cost Management โ†’ Cost analysis shows the spend so far this month.

How do I remove your access later?

Open rg-data-pipeline โ†’ Access control (IAM), remove our role assignment, then remove the guest user in Microsoft Entra ID โ†’ Users. Everything we built keeps working: it's yours.

We have an IT company. Should they do this?

Yes, that's often easiest. Send them this page, or copy them into our emails and we'll agree it with them directly.

We don't use Microsoft at all.

You can create an Azure account with your business email (see the tip at the top), or we can host it for you for a small monthly fee, agreed in writing. We'll explain both options on a call.