Forum Discussion

HR3038511's avatar
HR3038511
Helper I
1 year ago

Data Source Error / Incremental Refresh with Denodo

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!

2 Replies

  • 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"}

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    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