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...
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
1 year ago

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