# Which Data Source supports Direct Query Mode in Power

**URL:** <https://community.cdata.com/t/which-data-source-supports-direct-query-mode-in-power/710>\
**Category:** CData Drivers\
**Tags:** question, power-bi\
**Created:** [May 8, 2024, 1:17pm UTC](https://community.cdata.com/t/which-data-source-supports-direct-query-mode-in-power/710 "2024-05-08T13:17:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![PratikV](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/pratikv/32/1301_2.png) [@PratikV](https://community.cdata.com/u/PratikV)\
**Post date:** [May 8, 2024, 1:17pm UTC](https://community.cdata.com/t/which-data-source-supports-direct-query-mode-in-power/710/1 "2024-05-08T13:17:52Z")

</div>

Hi All,

Repeatedly, customers have raised inquiries regarding the compatibility of Power BI’s direct query mode with various data sources. They seek clarification on which specific data sources are supported by this feature

The sample image for the same is as below:

 ![954cfe98-1740-4878-b52a-233f4283a506.png](https://us1.discourse-cdn.com/cdata/original/2X/1/1af204de6c8fed3759a39786cd9a14eaccaa74c4.png)

The Answer to the question is that the support for direct query mode in Power BI is determined by Microsoft rather than CData. To ascertain which data sources are compatible with direct query mode, it’s advisable to refer to the provided link from Microsoft’s official documentation. This resource will offer comprehensive information regarding the supported data sources for direct query functionality within Power BI.

> **[Power Query connectors - Power Query](https://learn.microsoft.com/en-us/power-query/connectors/)**
>
> Find Power Query connector references and availability for Excel, Power BI semantic models, and Power Query Online.

Choose the data source relevant to your specific use case. If you find “DirectQuery” listed under the “Capabilities Supported” section for that particular data source, it indicates that the data source supports the Direct Query method.

For example, if you’re utilizing SQL Server as your data source, referencing the provided image and link confirms that Direct Query mode is indeed supported for SQL Server.

> **[Power Query SQL Server connector - Power Query](https://learn.microsoft.com/en-us/power-query/connectors/sql-server)**
>
> Includes basic information about products that use the connector, supported authentication types, prerequisites, and connection instructions.

 ![432e020d-e793-42c7-a4e6-76cdcf6efda5.png](https://us1.discourse-cdn.com/cdata/original/2X/0/0567811ba4917c927580beae8a9ad95b8f66ba4f.png)

---

<div class="post-metadata">

**Author:** ![Luçjano\_Capo](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/lu%C3%A7jano_capo/32/1638_2.png) [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\
**Post date:** [May 9, 2024, 11:59am UTC](https://community.cdata.com/t/which-data-source-supports-direct-query-mode-in-power/710/2 "2024-05-09T11:59:11Z")

</div>

Hi @PratikV !

Thank you for the information provided!

I acknowledge the importance of this information.&nbsp;Could we consider publishing it as a **Knowledge Base** article rather than a question on our CData Community? I believe it would be more beneficial as part of our **Troubleshooting** section within the **Editions** category. By creating a dedicated **Knowledge Base** article, we can provide clarity on which **Power BI** data sources currently support this feature, addressing any uncertainties our customers may have.

Thank you!

---

<div class="post-metadata">

**Author:** ![PratikV](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/pratikv/32/1301_2.png) [@PratikV](https://community.cdata.com/u/PratikV)\
**Post date:** [May 13, 2024, 10:45am UTC](https://community.cdata.com/t/which-data-source-supports-direct-query-mode-in-power/710/3 "2024-05-13T10:45:56Z")

</div>

Hi @Luçjano_Capo &nbsp;,

I suggest we consider storing this information on a community site rather than opting for a knowledge base article. By doing so, we foster a collaborative environment where users can contribute and benefit from shared insights and experiences. Additionally, the Microsoft site link I provided has been available for quite some time, potentially known to individuals who have encountered similar issues. Leveraging existing resources can streamline troubleshooting processes and provide support to a broader audience.