Events
Power BI DataViz World Championships
14 Feb, 4 pm - 31 Mar, 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
14 Feb, 4 pm - 31 Mar, 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.
Documentation
Add or remove a gateway data source - Power BI
Learn how to add or remove data sources to an on-premises gateway in Power BI. Get tips for managing your data sources efficiently.
Use a personal gateway in Power BI - Power BI
See information about the Power BI on-premises data gateway (personal mode) that you can use for connecting to on-premises data.
Connect to cloud data sources in the Power BI service - Power BI
Learn how to connect to cloud data sources and share connections in the Power BI service.