Power BI — Supported Data Sources

  • Flat Files
  • SQL Database
  • OData Feed
  • Blank Query
  • Azure Cloud platform
  • Online Services
  • Blank Query
  • Other data sources such as Hadoop, Exchange, or Active Directory

All

File

Database

Import vs DirectQuery

Advantages of Using DirectQuery

  • Using DirectQuery, you can build data visualizations on large datasets, which is not feasible to import in Power BI desktop.
  • DirectQuery doesn’t apply any 1GB data set limit.
  • With the use of DirectQuery, the report always shows current data.

Limitations of Using DirectQuery

  • There is a limitation of 1 million row for returning data while using DirectQuery. You can perform aggregation of more number of rows, however, the result rows should be less than 1 million to return the dataset.
  • In DirectQuery, all tables should come from a single database.
  • When a complex query is used in the Query editor, it throws an error. To run a query, you need to remove the error from the query.
  • In DirectQuery, you can use Relationship filtering only in one direction.
  • It doesn’t support special treatment for time-related data in tables.

Azure

Online Services

Other

--

--

--

Big Data,ios,android,Spark

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Reduce Cost and Increase Productivity with Value Added IT Services from buzinessware — {link} -

Go (Golang) just got a massive update

Excelize 2.6.0 Released — Go language API for spreadsheets (Excel) documents

Farewell 2016, Hello 2017!

Is Mbed OS on Arduino Nano 33 BLE ready?

Comparison: Rakam vs Keen.io

How to access services via the kube-api server by example

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
MultiTech

MultiTech

Big Data,ios,android,Spark

More from Medium

POWER BI vs TABLEAU

Data visualization with Power BI

Using vis-timeline in Power BI

Cheat Sheet — Calendar that starts with any date of the month — Just two variables apart