Who is this guide for?

Power BI user working from home

If you want to import and visualise public data locally in Power BI Desktop, first check that the computer you choose supports the Windows app. Microsoft Learn describes Power BI Desktop as a Windows app.

Local data researcher

If you run joins, sorts or other operations, it’s worth matching the memory capacity and SSD space to your datasets. DuckDB explains that some operations on datasets larger than the available memory may temporarily spill over to disk.

User with a small desk

If space is limited, a compact desktop may be worth considering. Just make sure you can connect the screens and peripherals you want to use. Check the ports and included accessories for the exact model configuration.

What should you look for?

Compact Windows mini PC

A good fit if: you want to use Power BI Desktop or have limited desk space.

Bear in mind: check the display outputs, the exact configuration and whether its upgrade options meet your plans.

Mac mini

A good fit if: your analysis software runs on macOS and you’re looking for a compact computer.

Bear in mind: Microsoft describes Power BI Desktop as a Windows app, so don’t assume it runs directly on macOS.

Desktop with more configuration options

A good fit if: you expect your local datasets or temporary files to grow and need clear upgrade options.

Bear in mind: a larger case or higher-spec configuration isn’t automatically necessary; check the upgrade options for the exact model.

What to consider What to look for Who should pay extra attention?
Software compatibility Check the system requirements for your analysis software. Microsoft describes Power BI Desktop as a Windows app. If I want to use my existing analysis software locally, I first check that it’s compatible with the operating system. Around 36% of consumers say software compatibility is their main concern.
Memory and storage Match the RAM and SSD space to your datasets and tasks, allowing for temporary files and free storage. When working with large joins or local files, I want to know how much memory and free SSD space my workflow needs. Around 29% of consumers prioritise processing datasets locally.
Fitting into your home office Check the size, display ports and which accessories are included with the exact model configuration. If my desk is small or I want to connect several screens, I want to know in advance how the PC will fit into my workspace. Around 21% of consumers prioritise a compact, complete workspace.
Total cost and after-sales support List the accessories you’ll need and check the service terms alongside your statutory consumer rights. If you still need a screen or input devices, you’ll also want to know what comes with the computer and what options are available if it develops a fault. Around 14% of consumers prioritise total cost and after-sales support.

Common buying mistakes

  • Choosing based on processor power alone

    The operating system may determine whether you can use the desktop app you need. Memory and storage use also depend on your analysis and the operations you run.

    First, list the software you need and try it with a representative dataset or query. Then compare the configurations.

  • Assuming a small PC is a complete workstation

    The Lenovo ThinkCentre Neo 50q Gen 5 configuration we reviewed doesn’t include a keyboard, mouse or screen. Without suitable peripherals, the computer may not be ready to use at your workstation straight away.

    Check what’s in the box and make sure the connections are compatible with your screens and input devices.

  • Confusing the manufacturer’s warranty with your full statutory rights

    A manufacturer’s warranty and your statutory rights against the seller are not the same thing. A commercial warranty period doesn’t automatically determine your statutory rights.

    Check the service terms and, if the product develops a fault, consider your statutory consumer rights too.

Brands to consider

Lenovo

The ThinkCentre Neo 50q Gen 5 configuration we reviewed is a compact business Windows PC for anyone short on desk space who wants to use Power BI Desktop.

  • For configuration 13B9CTO1WWNL2, Lenovo lists Windows 11 Pro, 16 GB of memory and a 512 GB SSD.
  • This configuration doesn’t include a keyboard, mouse or screen. The specifications don’t show how quickly the PC will process your datasets.

Apple

The Mac mini is a compact option if the analysis software you need runs on macOS.

  • For the M6 base configuration we reviewed, Apple lists 16 GB of unified memory, a 256 GB SSD and support for multiple displays.
  • These configuration details don’t show how the model will handle a specific dataset. Microsoft describes Power BI Desktop as a Windows app.

HP

The Pro Mini 400 G9 is a Windows mini desktop that offers a useful compact alternative for comparison.

  • For configuration 9H6Z2ET#ABH, HP lists Windows 11 Pro, 16 GB of RAM and a 512 GB SSD.
  • These configuration details aren’t an independent performance test. Also check the status of the exact model configuration before choosing.

Joybuy desktops for working with datasets

This selection includes Windows desktops that may suit local analysis. For each model, check the software configuration, available connections and the memory and storage space you’ll need.

OMEN 35L Gaming Desktop GT16-0160nd C2FK7EA#ABH

OMEN 35L Gaming Desktop GT16-0160nd C2FK7EA#ABH

The Windows 11 Home configuration described may suit a Windows workflow for working with datasets locally.

16 GB of DDR5 memory and a 1 TB SSD. The product description says the memory can be upgraded to 128 GB; HDMI 2.1 and DisplayPort 2.1 connections are also listed.

Place the PC on a hard, flat, well-ventilated surface, leaving at least 10 cm of clearance all around.

Joybuy
OMEN 16L Gaming Desktop TG03-0057nd C3YP0EA#ABH

OMEN 16L Gaming Desktop TG03-0057nd C3YP0EA#ABH

This desktop, as described, may suit a Windows workflow for working with datasets locally.

16 GB of DDR5 memory and a 1 TB SSD. According to the product description, the memory can be upgraded to 32 GB; HDMI 2.1 and DisplayPort 2.1 outputs are also listed.

According to the product title, Windows 11 Home is pre-installed but not activated. Leave at least 10 cm of ventilation space around the PC; use in an enclosed cabinet is not recommended.

Joybuy
Panoramic Gaming PC, Ryzen 7 5700X, 16 GB of DDR4 memory and 480 GB NVMe SSD

Panoramic Gaming PC, Ryzen 7 5700X, 16 GB DDR4, 480 GB NVMe SSD

The title describes a desktop with Windows 11 Home for a local Windows working environment.

16 GB of DDR4 memory and a 480 GB NVMe SSD. The product description lists a Wi-Fi adapter as included.

According to the product title, Windows 11 Home is pre-installed but not activated.

Joybuy
Gaming Desktop PC Ryzen 7 7800X3D, 32 GB of DDR5 memory and 1 TB NVMe SSD

Gaming Desktop PC Ryzen 7 7800X3D, 32 GB DDR5, 1 TB NVMe SSD

The Windows desktop described may suit local dataset work if the listed memory and storage configuration meets the needs of your own tasks.

32 GB of DDR5 memory and a 1 TB NVMe SSD. The product title lists Windows 11 Trial; check which Windows configuration you need.

Joybuy
Lenovo Yoga AIO 27IAH10 F0J2001DNY, 27-inch QHD all-in-one desktop

Lenovo Yoga AIO 27IAH10 F0J2001DNY, 27-inch QHD

This all-in-one may suit you if you’re looking for a Windows desktop with an integrated screen.

The description lists a 27-inch QHD screen, Windows 11 Home, 16 GB of memory and a 1 TB SSD. A wireless keyboard and mouse are also listed.

Joybuy

Frequently asked questions

Can I install Power BI Desktop on a Mac mini?

Microsoft describes Power BI Desktop as a Windows app. Choose a Mac only if your analysis workflow runs on macOS; don’t assume there’s a version of Power BI Desktop that runs directly on macOS.

Does my entire dataset need to fit in memory?

Not always. DuckDB explains that certain operations on datasets larger than the available memory may temporarily spill over to disk. The capacity you need also depends on your query, so check how much fast, free storage your workflow requires as well as the RAM.

What should I check when setting up my home workspace?

Check the display ports on the exact PC configuration and which input devices are included. If you’re using the workspace as an employee, the Dutch government says your employer has a duty of care to provide a good and safe home-working environment; this doesn’t necessarily apply to every private home office.

What happens if the PC develops a fault or doesn’t suit me after I buy it online?

When you buy as a consumer in the Netherlands, you have statutory rights against the seller in addition to any manufacturer’s warranty. What you could reasonably expect with normal use is what matters. For online purchases, you generally have up to 14 days after delivery to change your mind, subject to exceptions that you should check before buying.

Can I freely reuse personal data from public datasets?

No. The fact that data is publicly available doesn’t automatically mean it can be freely reused. The Dutch Data Protection Authority explains that the GDPR may apply to personal data from public sources and that a lawful basis may be needed. It notes an exception for use solely for personal or household purposes; assess the data and intended use separately from your choice of computer.