Forum Discussion
Use Dataflow in connection with Denodo
Hello,
thanks for your help.
I found the following article
https://docs.microsoft.com/de-de/power-query/dataflows/data-sources
It explains that the blank query feature is not supported with Denodo.
We will now try with ODBC, although it has some restrictions unfortunately.
Thank you
Best Regards,
Johann
Hello,
thanks for your help.
I found the following article
https://docs.microsoft.com/de-de/power-query/dataflows/data-sources
It explains that the blank query feature is not supported with Denodo.
We will now try with ODBC, although it has some restrictions unfortunately.
Thank you
Best Regards,
Johann
Hello, we are in the process of using Denodo as well
Just curious how you configured the gateway to connect to Denodo (the options used when setting up the gateway data source), and did you get your dataflow to connect to denodo (and how did you do it)
Appreciate any help,
Hello blopez11,
The dataflow(s) are connected to the Denodo sourc via ODBC connector (In Power BI Service). Its working properly since a year now.
We offer those dataflows whether as big data providers or more specific data pools, according to what the business requires. They are then starting to build up their reports on those dataflows, transform then once more and build measure upon.
About your question how we connected the on-premise gateway to Denodo:
An ODBC connection was set up on the Gateway server, leading to the Denodo source system. About the exact installation process I can't tell much as it is done by another department, but from what I know, you have to follow a guided installation.
Do you have any specific question? Maybe I can find out..
Best Wishes,
Johann