Which Data Source supports Direct Query Mode in Power

Live Connectivity CData Drivers
,
1

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
954cfe98-1740-4878-b52a-233f4283a506.png857×472 50.4 KB

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.

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.

432e020d-e793-42c7-a4e6-76cdcf6efda5.png
432e020d-e793-42c7-a4e6-76cdcf6efda5.png847×716 43.9 KB

2

Hi @PratikV !

Thank you for the information provided!

I acknowledge the importance of this information. 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!

3

Hi @Luçjano_Capo  ,

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.