Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article provides information about Power BI data sources, including considerations, limitations, and links to more resources.
Power BI uses Power Query to connect to data sources. Power BI data sources are documented in Power Query (including Power BI) connectors.
Each data source article in the Power Query documentation describes connector capabilities, like whether DirectQuery is supported. The following image shows the Capabilities supported section for Azure Data Explorer (Kusto), which shows that DirectQuery is supported 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.
Considerations and limitations
- Many data connectors for Power BI Desktop require Internet Explorer 10 or later for authentication.
- Some data sources appear in Power BI Desktop optimized for Power BI Report Server, but Power BI Report Server doesn't support them after you publish. See Power BI report data sources in Power BI Report Server for the list of supported data sources.
- Power BI Desktop and the Power BI service might send multiple queries to get schema information or data, depending on whether data is cached. It's by design. For details, see why a query might run multiple times.