Use Dataflow in connection with Denodo

[Johann_32]

Hello,

we would like to use Denodo in Dataflows of Power BI Service. 

Unfortunately, there is currently no Denodo connector available for Dataflows.

Therefore, we use the "blank query" feature when adding new entitites in Dataflows. Also, we already have a working on-premise data gateway (non personal) in place that delivers data for Denodo.

What are the steps?

1. We connect via Power BI Desktop to the database via Denodo connector --> OK

2. We publish the report and dataset to Power BI Service --> OK

3. We step back to the "Transform Data" in Power BI Desktop and click on "Advanced editor" to get the command we need later for the blank query of Dataflow --> OK

4. We connect the published dataset to the data gateway of Denodo --> OK

5. We click on create Dataflow, choose new entity, then "Blank Query" and insert the string we have copied form the Advanced editor. To make it easier for the moment we do not choose a on-premise data gateway. --> OK

6. An error message appears " Expression.Error: The import Denodo.Contents matches no exports. Did you miss a module reference?" --> NOK

Is it possible that the "Denodo.Contents" expression is not working when using "blank query"?

I would appreciate any support in this case. 

Our target is to achieve a connection with dataflows to Denodo and ODBC as a dataflow connector is not an option.

Thank you 

Johann

[Johann_32 · Accepted solution]

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 

[blopez11]

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,

[Johann_32]

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

[blopez11]

Thank you @Johann_32 , This is very helpful and exactly what I was looking for

[v-janeyg-msft]

Hi, @Johann_32 

The problem should be in the fifth step. I don’t know much about this knowledge. Did you change the function name of Denodo.Contents. It needs to be consistent.

Why not use odbc connection?

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.