You can translate the question and the replies:

Power BI Direct Query to SQL dn through Denodo

Hey , I am new to denodo. I have a powerbi file in direct query mode . it uses odbc connection to denedo serving layer which is connected to sql dB. when end user interact with powerbi, it will generate sql queries and pass that to underlying source in this case it passes denedo first then to sqldB. the main question is how does denedo pass through sql queries? what kind of sql it uses? does it have its own sql parser?
user
04-11-2021 03:28:47 -0400

1 Answer

Hi, Denodo has its own sql parser and will delegate the query to the data source as much as possible depending on the data source capability to improve the performance. The delegated functions can be found in the Configuration >- Source Configuration of the data source wizard. You may refer to the section [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/data_source_configuration_properties/data_source_configuration_properties) of the Virtual DataPort Administration Guide for details. Hope this helps!
Denodo Team
04-11-2021 05:37:14 -0400
You must sign in to add an answer. If you do not have an account, you can register here