Connecting Denodo With PowerBI

[Anonymous]

Hi All, has anyone here used Denodo as a datasource with PowerBI ? I see that there is no connector available in powerbi for Denodo, i am wondering if anyone has connected to Denodo using ODBC and how was their experience using Denodo with PowerBI.

My cleint has Denodo as their Data virtualization tool.

Thanks.

[nisargdshah]

Hi All,

I have connected PowerBI Desktop with Denodo using Denodo PowerBI connector given by Denodo. During the conenction powerbi asks for Import or Direct Query and I used direct query. The report gets bulit very well and connection works well from powerbi desktop to denodo. However, when I share such report on powerbi cloud then it does not work and gives error as

"The data refresh failed due to an error in retrieving dataset. Please try again later or contact support."

When the same source in the report was changed to use Import option then it worked.

So I would need help in resolving the dataset refresh issue mentioned above when the option Direct Query was used while connecting to denodo.

Can you please help me out.

Thank & Regards,

Nisarg Shah

nisarg.shah@mastek.com

[v-danhe-msft]

Hi @Anonymous,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[Anonymous]

Hi All,

Have you used build in Power BI Denodo connector and have you used it with direct query on the Power BI Service with Enterprise Gateway? If yes how it works?

Thank you.

Regards,

Pawel

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, current DENODO support the ODBC driver, you can refer to this link https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_odbc/configuration_of_the_odbc_driver_on_windows/set_up_a_dsn_on_windows

to set a DSN on windows and add it into the ODBC Data . Then you can use the Power BI Desktop to connect the DENODO. Please note the ODBC DSN bit version needs to match Power BI desktop bit version.

Regards,

Daniel He

[clingant]

Note that in April 2018 Denodo came out with a Power BI ODBC connector that can be downloaded from the Denodo Connects site.  https://community.denodo.com/answers/question/details?questionId=9060g0000004F2OAAU&title=PowerBI+Di...

[clingant]

Note that in April 2018 Denodo came out with a Power BI ODBC connector that can be downloaded from the Denodo Connects site.  https://community.denodo.com/answers/question/details?questionId=9060g0000004F2OAAU&title=PowerBI+Di...