Data Source Error / Incremental Refresh with Denodo

[HR3038511]

Hi, 

My data set is connected to Denodo. After I activated incremental refresh I get the following error:

Data source error: {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"The data source '{\"protocol\":\"x-datasource\",\"authentication\":null,\"address\":{\"kind\":\"DenodoForPowerBI\",\"path\":\"{\\\"DSN\\\":\\\"SERVER=si0vm05540.bsh.corp.bshg.com;DATABASE=vdb_finance_and_controlling;PORT=9996\\\"}\"},\"query\":null}' depends on custom data connector and is not discovered by Power BI services. Please follow steps at https://aka.ms/powerbiCustomConnectorConfig to finish the configuration of on-premise data gateway and data source."}}],"exceptionCulprit":1}}}

In order to set up the incremental refresh I set up the parameter RangeStart and RangeEnd in Power Query. I then use a Query (SELECT * ...) in Power Query to pull the data and to set up the filtering of the date column by the RangeStart and RangeEnd parameter (#"Run Native Query"). My Power Query code looks like this:

let
Quelle = Denodo.Contents(Denodo_link, null, []),
vdb_al_plm_Database = Quelle{[Name="vdb_finance_and_controlling",Kind="Database"]}[Data],
vdb_al_plm_Schema = vdb_al_plm_Database{[Name="vdb_finance_and_controlling",Kind="Schema"]}[Data],
#"Run Native Query" = Value.NativeQuery( vdb_al_plm_Database ,"
SELECT * from dv_mendix_mtt_"&Environment&"_reporting_snapimpactdistributionobj WHERE
""changeddate"" >= '" & DateTime.ToText(RangeStart, "yyyy-MM-dd hh:mm:ss") & "' and ""changeddate"" < '" & DateTime.ToText(RangeEnd, "yyyy-MM-dd hh:mm:ss") & "'",null,[EnableFolding=true]),
#"Changed_Type" = Table.TransformColumnTypes(#"Run Native Query",{{"changeddate", type datetime}})
in
Changed_Type

Does anybody know how to fix the data source error?

Thanks!

[v-yohua-msft]

Hi, @HR3038511 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yongkang Hua

[AmiraBedh]

Check if the Denodo custom connector (Denodo.mez or similar file) is placed in the correct folder:

%USERPROFILE%\Documents\Power BI Desktop\Custom Connectors (for Power BI Desktop testing).

And for Power BI Service: Place the connector in the on-premises data gateway's custom connector folder.

Then you need to configure the On-Premises Data Gateway and enable Custom Data Connectors.

Next step you need to add the data source to the gateway :

• Go to the Power BI Service.
• Navigate to Manage Gateways > Select your gateway.
• Add the Denodo data source:
  • Data Source Type: Custom Data Connector.

  • Configure the connection string, such as:

{"DSN":"SERVER=si0vm05540.bsh.corp.bshg.com;DATABASE=vdb_finance_and_controlling;PORT=9996"}