Forum Discussion
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
- AmiraBedhSuper User
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"} - AnonymousNot 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