Scheduled refresh not working for Denodo datasource

[tom_deridder]

Hi,

Currently we are experiencing failure of scheduled refresh for datasets with Denodo as datasource.

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: Unable to refresh the model (id=5387496) because it references an unsupported data source.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: c67a016f-52d6-42db-8b18-a96a57b1c2f2
Request ID: 3b91f62b-67ce-be41-7f40-c6de8b444484
Time: 2018-12-22 11:08:29Z

On the settings for the datasource in "Manage gateways" we get this message:

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for pm_t003o_order_types
Discover Data Sources
Query contains unknown funtion name: DenodoForPowerBI.Contents.

We experienced this with november-release of On premises data gateway, and with the December release (3000.0.265).

[v-yuezhe-msft]

@tom_deridder,

How  do you connect to Denodo data source in Power BI Desktop?

Could you please share  the M code in Advanced Editor of your query in power BI Desktop? Based on the above error message, it doesn't support refreshing the data source which contains DenodoForPowerBI.Contents function.

Regards,
Lydia

[tom_deridder]

Hi, Denodo is a supported datasource since October 2018, and scheduled refresh was working in the October-release. I ended up in reinstalling the gateway, issue solved now. Don't know what was causing the problems. Case closed for now 🙂

[dbullivant]

Hello has there been any progress on the issue with scheduling refreshes of Denodo-sourced data.  Similar to Tom, I am trying to refresh a dataset using our Gateway's Denodo connection.  It fails frequently.  The same dataset can be refreshed successfully in seconds.

Attached is the script from the advanced editor for 4 queries in the report:

1.

let
Source = Sql.Database("PLKFSQL10V\PROD2012", "EDM", [Query="SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;#(lf)SELECT GETDATE() AS Last_Refresh;", CommandTimeout=#duration(0, 0, 5, 0)])
in
Source

2.

let
Source = Odbc.DataSource("dsn=Denodo64AProd1", [HierarchicalNavigation=true]),
admin_Database = Source{[Name="admin",Kind="Database"]}[Data],
ana_workflow_Schema = admin_Database{[Name="ana_workflow",Kind="Schema"]}[Data],
open_case_timeliness_View = ana_workflow_Schema{[Name="open_case_timeliness",Kind="View"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(open_case_timeliness_View,{{"create_datetime", type datetime}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"branch_level", "Branch Level"}, {"branch_name", "Branch Name"}, {"case_id", "Case ID"}, {"case_status", "Case Status"}, {"create_date", "Create Date"}, {"create_datetime", "Create Date/Time"}, {"current_stage", "Current Stage"}, {"general_manager", "GM"}, {"workbasket_id", "Workbasket ID"}, {"aged", "Aged"}, {"division", "Division"}, {"market", "Market"}})
in
#"Renamed Columns"

3.

let
Source = Odbc.DataSource("dsn=Denodo64AProd1", [HierarchicalNavigation=true]),
admin_Database = Source{[Name="admin",Kind="Database"]}[Data],
ana_workflow_Schema = admin_Database{[Name="ana_workflow",Kind="Schema"]}[Data],
open_case_timeliness_View = ana_workflow_Schema{[Name="open_case_timeliness",Kind="View"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(open_case_timeliness_View,{{"create_datetime", type datetime}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"create_date", "market", "division", "aged", "case_id", "create_datetime", "current_stage", "case_status"}),
#"Removed Duplicates" = Table.Distinct(#"Removed Columns"),
#"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"workbasket_id", "BU"}, {"branch_level", "branch level"}, {"branch_name", "branch name"}, {"general_manager", "GM"}})
in
#"Renamed Columns"

4.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("pVXbbhMxEP2VUSQkkMql3OGtbaSCRAG1RTxUPLi7k6xVx17G3qzCU38DCX6uX8IZO9kmoAhaXrK7jufMOWfG47Oz0e5oZ7Q35RqPN6Gn4GpKDVNlIpONdI5nTcFT37C//seI2Dn+sJ4M9UEusO+CE33tuOMHRKcNi+5ihAgz1TZWwokptMkGH8nMjXXm3PFrOjEzprFZ7NBHsUHK64c5Cz3W9/hg9GXnbPQYBPfF+Kqhdzxnh08kUYpKKtpvwJ7k9/OyawKovrF408U1jggxzoXKJK4LVZob13EkBE6ZJhJm9I0lUAo0gcwNPcbFMKjIq5roIEgbBIh0zHPLPRlf00mDADxY5rYCvClc11UoGR8SmbZ1tlI/NOmGpakxadgWo516YOZNRWix58m1Pe/hZ3YHQRPLKGgVfDLWl/ST0Mn9CtRMleBx5y2KtjLN1uyTRZRAaPBT6m0qBlY2LbKqmFTmhtfZoCFbdmhIKTyBSV71g3QFeDEO1appKqFrsytZmnNrqmPxeqvcpxB4oI34doy3T0XDGnmtiVFtSZkqLhjNLARZ/5vBGe/ZCu8E6rqIrw/eLagBOZMVd1GBvFZWS6JtZ9G2d0/3xzlZ19awJd7LaM8VTVh9GuNn2aq6oVRTnVuypx4pqry3LtJebAY/PLWzDQStQc79d6iXCtUJ7E8qbKo4x9wKR6wsD86grS8tPqABDO61EqbYH3P5eiN1VCNbx3oASpZXQB3buY1Y0SkC/41UzaKcquxOKR0wtJ0wM/ZasaZE7z5CzOERfrRvV31lfQ3EujOOGowkLZwuH7IHuKMj46FGqA3RKhEtiqHWSLJV54xs9MqujrgjI1rrm9PTubM2jJRnNzvHN5gurbq6/I7eRwMP/aVcry5/rMVdXf4kHbOkY2caZLGEf7IJT3eWpW5Z9KxA5f8m0kJqyfIsWoakkOBiaDHSdZwvueihGkbwjYQOUdtkPluHvqXI7Un+XaKezNV9cyOFq6BtAl+sAd9S39YU/y5PD/zn68mGm73cyH8cbr0DV8NVT8CkS52UWxJQX34B", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Sort Order" = _t, Metric = _t, Definition = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Sort Order", Int64.Type}, {"Metric", type text}, {"Definition", type text}})
in
#"Changed Type"