Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article provides general information on Power BI data sources including considerations, limitations, and links to additional resources.
Power BI uses Power Query to connect to data sources. Power BI data sources are documented in the following article: Power Query (including Power BI) connectors.
Each data source article in the Power Query documentation describes the capabilities of the data connector, such as whether DirectQuery is supported. The following image shows the Capabilities supported section for Azure Data Explorer (Kusto), where it states that DirectQuery is supported for the connector in Power BI. If DirectQuery (or any other capability) isn't listed, the capability isn't supported.
For a list of the connectors available in Power Query, see Connectors in Power Query.
For information about dataflows in Power BI, see Configure and consume a dataflow.
The following articles provide more information about Power BI and connecting to data:
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Get data in Power BI - Training
You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.