Ratings and Reviews 0 Ratings

Total 0 out of 5 stars
ease 0 out of 5 stars
features 0 out of 5 stars
design 0 out of 5 stars
support 0 out of 5 stars

This software has no reviews. Be the first to write a review.

Write a Review

Ratings and Reviews 1 Rating

Total 5 out of 5 stars
ease 5 out of 5 stars
features 5 out of 5 stars
design 5 out of 5 stars
support 3 out of 5 stars

Alternatives to Consider

  • Google Cloud BigQuery Reviews & Ratings
    4.5 out of 5 stars 2,037 Ratings
    Company Website for Google Cloud BigQuery
  • SCIKIQ Reviews & Ratings
    4.6 out of 5 stars 14 Ratings
    Company Website for SCIKIQ
  • AnalyticsCreator Reviews & Ratings
    4.6 out of 5 stars 46 Ratings
    Company Website for AnalyticsCreator
  • Denodo Reviews & Ratings
    4.6 out of 5 stars 388 Ratings
    Company Website for Denodo
  • TIMi Reviews & Ratings
    4.9 out of 5 stars 68 Ratings
    Company Website for TIMi
  • ChatD&B Reviews & Ratings
    Company Website for ChatD&B
  • DataHub Reviews & Ratings
    4.5 out of 5 stars 10 Ratings
    Company Website for DataHub
  • DbVisualizer Reviews & Ratings
    4.8 out of 5 stars 593 Ratings
    Company Website for DbVisualizer
  • Semarchy xDM Reviews & Ratings
    4.7 out of 5 stars 64 Ratings
    Company Website for Semarchy xDM
  • Plauti Reviews & Ratings
    4.4 out of 5 stars 124 Ratings
    Company Website for Plauti

What is Microsoft Power Query?

Power Query offers an intuitive approach for connecting to, extracting, transforming, and loading data from various origins. Functioning as a powerful engine for data manipulation, it boasts a graphical interface that makes the data retrieval process straightforward, alongside a Power Query Editor for applying any necessary modifications. Its adaptability allows for integration across a wide array of products and services, with the data storage location being dictated by the particular application of Power Query. This tool streamlines the extract, transform, and load (ETL) processes, catering to users' diverse data requirements. With Microsoft's Data Connectivity and Data Preparation technology, accessing and managing data from hundreds of sources is made simple in a user-friendly, no-code framework. Power Query supports a wide range of data sources through built-in connectors, generic interfaces such as REST APIs, ODBC, OLE, DB, and OData, and it even provides a Power Query SDK for developing custom connectors to meet specific needs. This level of flexibility enhances Power Query's value, making it an essential resource for data professionals aiming to optimize their workflows and improve efficiency. As such, it empowers users to focus on deriving insights from their data rather than getting bogged down by the complexities of data handling.

What is Datplan DataPull?

Build a repeatable reporting workflow with Datplan DataPull for Windows. It prepares supported accounting and CRM records from Xero, QuickBooks Online, TallyPrime and HubSpot as related reporting tables. Companies House discovery is available separately. Businesses can use the outputs for management reporting. Accountants and consultants can offer Dashboard as a Service, combining report setup, scheduled updates where supported and optional client reviews. Practices define their own scope and fees. Reporting options include custom desktop dashboards, ready-made browser reports and CSV/JSON files for Excel, Power BI, Tableau or Qlik. For client sharing, publish completed files to an authorised OneDrive or SharePoint folder with the intended Microsoft access permissions. A report shows the latest completed data refresh, rather than continuously querying the accounting source. Source datasets are prepared in the customer’s Windows environment, without a Datplan-hosted business-data warehouse. Online account, plan and source controls still apply. Each company/source has separate files; Datplan does not automatically consolidate different systems. The app and demo data are free; live connections require the relevant paid source plan. Scheduling, Audit Analytics and usage allowances vary by source and plan. The Windows session, PC and source must be available for scheduled acquisition. External BI tools and source providers have their own licensing and requirements.

Media

Media

Integrations Supported

QuickBooks Online
Acterys
Apache Hive
Azure Cosmos DB
Azure Costs
CData Connect
Dremio
GitHub
IBM Db2
InterSystems IRIS
Kyligence
Microsoft Excel
Microsoft Power Apps
Mixpanel
MySQL
PostgreSQL
Zendesk

Integrations Supported

QuickBooks Online
Xero

API Availability

Has API

API Availability

Pricing Information

Pricing not provided

Pricing Information

Free demo; paid source plans
The Windows app and included demo data are free. A paid source plan is required to connect live business data. Price, currency, billing period, allowance and scheduling depend on the source and plan. Compare current source plans on the Datplan website. Provider licences and limits still apply.
Free Version

Supported Platforms

SaaS
Windows
Mac

Supported Platforms

Windows

Customer Service / Support

Web-Based Support

Customer Service / Support

Web-Based Support

Training Options

Documentation Hub

Training Options

Documentation Hub

Company Facts

Organization Name

Microsoft

Date Founded

1975

Company Location

United States

Company Website

powerquery.microsoft.com/en-us/

Company Facts

Organization Name

Datplan

Date Founded

2017

Company Website

www.datplan.com

Categories and Features

Data Integration

Not specified

Data Preparation

Not specified

ETL

Not specified

Categories and Features

Data Integration

Not specified

Popular Alternatives

Microsoft Power BI Reviews & Ratings

Microsoft Power BI

Microsoft
4.4 out of 5 stars

Popular Alternatives

TallyPrime Reviews & Ratings

TallyPrime

Tally Solutions
4.4 out of 5 stars
FastQueryBuilder Reviews & Ratings

FastQueryBuilder

Fast Reports
TaskAutomate Reviews & Ratings

TaskAutomate

Just Think Technologies
AnalyseAI Reviews & Ratings

AnalyseAI

Tegain Private Limited
TROCCO Reviews & Ratings

TROCCO

primeNumber Inc
Dear.so Reviews & Ratings

Dear.so

Macrofix Software Private Limited
Comsky Reviews & Ratings

Comsky

Comhard Technologies Pvt. Ltd.