BLOG

Around the horn with API news, blog goodies, and press releases.

Blog/November 7, 2026/By James Fletcher

Datpaq for Power BI: Because Data Still Has to Get There

The Datpaq Power BI Connector provides Power BI professionals with direct access to Datpaq API data services from within the Power Query workflow.

Frustration to Foundation

For the past two years, I’ve been building Datpaq around a problem I kept running into as a Fabric and Power BI Architect and Engineer.

I was building the same things over and over.

Different customer. Different project. Different semantic model.

Same plumbing.

I needed reference data. I needed geographic data. I needed validation. I needed transformations, lookups, sample data, utility functions, enrichment services, and dozens of other small pieces that somehow found their way into project after project.

Eventually I started asking a pretty simple question:

Why am I rebuilding this every time?

That question became Datpaq.

AI is Here and You're Still Repeating Your Data Entries

AI Is Everywhere. Data Ingestion Didn’t Disappear.

Right now, almost every technology conversation eventually turns into AI.

AI this. Copilot that. Agents. Models. Automation. And a lot of that technology is genuinely exciting.

But there is a less glamorous reality underneath all of it:

The data still has to get there.

Before you can build the report, create the semantic model, train something, analyze something, or ask an AI assistant a clever question, somebody still has to acquire, validate, transform, enrich, and load the data.

That work didn’t disappear.

Datpaq is designed to make some of it easier.

Datpaq Is Now Available Directly in Power BI

You Deserve Infastructure. Not Retrofits

Datpaq has an official Power BI connector that brings Datpaq API services directly into the Power Query experience.

Instead of leaving Power BI, writing one-off API integrations, managing URLs manually, parsing JSON responses, and repeating the same integration work across projects, you can connect to Datpaq from Power BI and work with the available services through the Navigator.

Choose the data you need, provide the required parameters, preview the results, and load them into Power BI.

From there, the data becomes part of the same Power Query and semantic-model workflow you already use.

For example, loading U.S. state data can be as simple as selecting the Datpaq connector, choosing the States operation, and loading the resulting table into your model.

No separate utility project. No throwaway script. No rebuilding the same lookup for the fifth time.

Built for Power BI, Not Bolted Onto It

A lot of API integrations technically work with Power BI. That doesn’t necessarily make them pleasant to use.

The Datpaq connector was built specifically around the Power Query connector architecture. Operations are exposed through the Navigator with typed parameters, metadata, previews, and tables designed to work naturally with Power BI.

Behind the scenes, the connector uses a controlled build and release pipeline that validates the connector with the Power Query engine before producing a production package.

Production releases are then malware-scanned, digitally signed with Datpaq’s code-signing certificate, verified, and published with a SHA-256 checksum.

That matters because this isn’t a random .pq file someone copied from a forum.

It’s a product.

One Connector, A Growing Set of Data Services

The goal isn’t to replace the systems that contain your business data.

Datpaq is there for all of the supporting data and utility work that tends to accumulate around those systems.

  • Reference data.
  • Geographic and location services.
  • Network and IP utilities.
  • Time and calendar operations.
  • Sample data.
  • Validation.
  • Conversions.
  • Lookups.
  • Enrichment.

And the collection will continue to grow.

Why Did We Do This?

The larger goal is simple: reduce the amount of disposable integration code Power BI and Fabric professionals have to write just to get useful data into a project.

Datpaq wasn’t designed by starting with a list of features and trying to invent reasons people might use them.

It came from doing the work.

After enough projects, patterns become obvious. You know which utilities you’re going to need again. You know which APIs you’re tired of wiring up. You know which Power Query functions keep getting copied from one solution to another.

Datpaq is my attempt to turn those repeated patterns into something reusable for the broader Power BI and Fabric community.

I’ve spent roughly two years getting it to this point.

Now it’s finally ready to start leaving my development environment and getting into yours.

Where to Find It?

Download the Datpaq Power BI Connector

The Datpaq Power BI connector is available as a signed production download through the official Datpaq GitHub repository.

Download: GitHub

Additional documentation, API access, and product information are available at: datpaq.com

What's Next?

This is only the beginning. There is a lot more coming.

Previous

Post 1 of 16

Next