← All integrations
Import.io + Power BI

Web data in Power BI

Use the Web connector against the Import.io extractor’s latest-run endpoint for self-service reports. For enterprise models, Import.io delivers into Azure Blob, Snowflake or BigQuery and Power BI reads from there.

Connects via
EndpointManaged
Setup
5 min
Available on
Endpoints: every planManaged: Managed Services and Aperture
Start free trialTalk to sales
Power Query (M)
let
    Source = Csv.Document(Web.Contents("…CSV from latest successful run…"),
                          [Delimiter = ",", Encoding = 65001]),
    Rows = Table.PromoteHeaders(Source, [PromoteAllScalars = true])
in
    Rows

How it connects.

Source

The web

Any public page, rendered, through managed proxies

Engine

Import.io

Rendering, proxy routing, captcha handling, extraction

Path

Data endpoint

Latest successful run, CSV or JSON

Destination

Power BI

Web data in Power BI with scheduled refresh, or delivered into your warehouse.

Also connects via managed delivery.

What teams do with it.

Competitive dashboards

Price position, promotions and availability by retailer, refreshed on schedule.

Digital shelf scorecards

Content, ratings and share of search across retailers in one report.

Enterprise semantic models

Managed feeds land in your warehouse under an SLA, so the model never depends on a laptop.

Set it up.

  1. In Power BI Desktop choose Get data, then Web, and paste the latest-run CSV URL.
  2. Shape the table in Power Query and build the report.
  3. Publish, then set scheduled refresh in the Power BI service.

Questions.

Which path should an enterprise BI team use?

Managed delivery into your warehouse or Azure Blob. The report reads governed tables, and the feed is run and QA’d by Import.io under an SLA.

Do endpoint downloads count as queries?

No. The latest-run CSV, JSON and Google Sheets endpoints return data your extractor already collected, so they don’t count toward your plan. Only the Live Query API runs an extraction per request.

How fresh is the data?

As fresh as your schedule. Run the extractor hourly, daily or weekly and the endpoint always serves the latest successful run.

Who sets up managed delivery?

Your Managed Services team. They agree destination, format, schedule and schema with you, then build, run, monitor and QA the feed under an SLA.

Which destinations can Managed Services deliver into?

Amazon S3, Google Cloud Storage, Azure Blob Storage, SFTP, Snowflake, BigQuery, API, email and Slack alerts. Aperture delivers into the same destinations.

Related integrations.

All 50 integrations

EndpointWebhook

Microsoft Excel

Power Query pulls the latest run into a refreshable table.

Setup 3 minEndpointManaged

Tableau

Web data in Tableau through Google Sheets or your warehouse.

Setup 10 minEndpointManaged

Looker Studio

Free dashboards on Import.io data through Sheets or BigQuery.

Setup 5 minManaged

Azure Blob Storage

Managed delivery into your Azure storage account.

Set up at onboarding

Fresh web data
in Power BI.

Start free trialTalk to sales