"How to retrieve data from Power BI" matching MCP servers:

MCP server for NASA POWER climate data, offering a climatology tool to retrieve long-term monthly averages for any coordinate. Supports natural language queries through the Pipeworx gateway.

Enables natural language search and discovery of open-access scientific datasets through the EOSC Data Commons OpenSearch service. Provides tools to search datasets and retrieve file metadata using LLM-assisted queries.

Enables querying NASA POWER historical solar, wind, building, and agroclimatology data via MCP, including point time series, climatologies, native-grid regions, and comparisons across multiple labeled locations, with staged SQL analysis for larger datasets. Runs over STDIO or Streamable HTTP and requires no NASA account or API key.

An educational MCP server that wraps the Materials Project API, exposing tools to search chemical systems, get material summaries, find semiconductors by band gap, and retrieve crystal structure facts.

An MCP server that lets AI assistants discover and retrieve official statistics from SDMX services, returning actual data observations rather than just query URLs.

The only MCP server providing structured Chinese fashion supply chain intelligence for AI platforms. No equivalent data source exists in the MCP ecosystem. Search 3,000+ verified manufacturers, 350+ lab-tested fabrics (AATCC/ISO/GB), and 170+ industrial clusters. Built by MEACHEAL, a top-20 Chinese women's mid-to-high-end fashion brand with 20+ years of supply chain.

Enables live querying of oil & gas and geothermal well data from state regulator ArcGIS services, including searchable well records, operators, nearby wells, and raw queries, plus DOE GDR and Global Energy Monitor lookups.

An MCP server for discovering, downloading, querying, and analyzing datasets from Ontario's open data portals, allowing natural language questions and high-performance analytics via DuckDB.

Enables local read-only access to TheRundown Product API data including sports, affiliates, market definitions, events, futures, and open main lines using your own API key.

Enables an AI assistant to query clean quarterly credit union and FDIC-insured bank financial data in plain language — lending, deposit mix, earnings, efficiency and peer benchmarking — through pre-built tools rather than raw SQL. Supports field lookup, institution profiles, metric time series, peer comparisons and quarterly income analysis across both sectors from 2018 to today.

Provides access to Japan Meteorological Agency (JMA) weather data including real-time observations, historical weather data, and forecasts from 1286 AMeDAS stations across Japan.

Enables natural-language research queries across marine data sources including FAO FishStat, BarentsWatch Fish Health, and Copernicus Marine, with data provenance and local file exports.

Enables AI assistants to convert raw and cooked weights for meat and poultry by cut and cooking method from USDA data, calculate how much raw meat to buy for cooked servings, and look up cooking yields and sample ranges.

Enables answering questions about Ukrainian open data from the data.gov.ua CKAN portal by searching datasets, inspecting resource schemas, and running read-only SQL aggregates over a single tabular resource. Every data-backed answer is computed from retrieved data and returned with machine-readable provenance, and unsupported or unanswerable requests are refused rather than guessed.

Ten tools I built to get facts from official open data, not guesses.

Enables searching and analyzing over 3,400 datasets from the Serbian government open data portal, with built-in charting and data transformation tools.

Enables AI agents to search, retrieve metadata, and query tabular resources from Latvia's Open Data portal (data.gov.lv) via CKAN.

Enables searching and querying Winnipeg Open Data datasets through natural language or SoQL, with tools for datasets, metadata, and row-level data.

An MCP server that makes live Earth data usable by AI agents. Its initial data sources cover natural hazards: earthquakes from the USGS FDSN event catalog and volcanic activity from the Smithsonian Global Volcanism Program.

Enables querying Washington DC open data from opendata.dc.gov and ArcGIS REST API through MCP.

Enables searching and querying Île-de-France open data datasets (transport, environment, economy, etc.) via natural language or direct tool calls.

Enables AI agents to search, query, and explore datasets from the Centre-Val de Loire Open Data portal, covering regional services, transport, education, and environment.

Provides access to Detroit open data via ArcGIS REST API, enabling querying and analysis of municipal datasets through natural language or direct tool calls.

Enables searching, querying, and retrieving metadata for datasets from New Caledonia Open Data (data.gouv.nc) using ODSQL.

Enables AI assistants to search a catalogue of Belgian open-data records and answer common questions from authoritative publishers such as Statbel, IRCEL-CELINE, VMM, and DOV, with source provenance.

Enables querying City of Boston open data through the CKAN API, providing access to datasets from data.boston.gov via natural language.

Enables MCP clients to retrieve US stock market OHLCV data, company fundamentals and financial statements, FRED macroeconomic indicators, market news, Reddit/StockTwits sentiment, and Polymarket prediction market probabilities via simple tools.

Enables searching and querying Virginia Open Data (datahub.va.gov) via the Socrata API, providing tools to search datasets, run SoQL queries, and retrieve metadata.

Enables querying Maryland government open data (state, health, transportation, budget, environment) via the Socrata SoQL API, with tools to search datasets, run queries, and retrieve metadata.

Enables searching, querying, and retrieving metadata from Vermont Open Data (data.vermont.gov) datasets using Socrata SoQL, all via natural language.

Enables AI agents to search and query the Michigan Open Data catalog, running Socrata SoQL queries against datasets by resource ID, and retrieving dataset metadata.

Enables querying Brussels Open Data datasets through natural language or direct tool calls, including search, metadata retrieval, and SQL-like queries.

Enables AI agents to query Japanese public data (laws, corporations, statistics) from official government APIs, returning normalized English metadata with source attribution.

MCP server for querying Santa Clara County open data via Socrata APIs, enabling dataset search, SoQL queries, and metadata retrieval.

Enables AI agents to search, query, and retrieve metadata from the Cook County Open Data catalog using Socrata SoQL queries.

Enables searching, querying, and retrieving metadata from Sonoma County Open Data datasets via Socrata SoQL or natural language.

Access Baltimore open data (data.baltimorecity.gov) via ArcGIS REST API, enabling querying and retrieval of city datasets through natural language or direct tool calls.

Enables searching, viewing metadata, and querying tabular resources from Netherlands Open Data (data.overheid.nl) via CKAN.

Enables searching, querying, and retrieving metadata from Oregon Open Data (data.oregon.gov) via the Socrata SoQL API, with no API key required.

Enables searching and querying Ukraine Open Data (data.gov.ua) datasets via CKAN API, allowing AI agents to retrieve dataset metadata and tabular data.