cancel
Showing results for 
Search instead for 
Did you mean: 

Paginated report fails when using parameters with date

I am running a paginated report, witha VQL query, connecting through ODBC to Denodo virutal database.

 

When using the following sytax in query:

 error_date >= addday(current_date(), ? * -1)

the report works fine in Report Builder, but it fails after publishing to the Power BI Service with the following error: 

 

"Error on the service when it fails : “Data for this report could not be loaded due to an on-premises gateway error. A query in this report may be returning a field which is not supported by the on-premises gateway. Please remove any fields containing user-defined types or unsupported gateway types and try again.Additional steps are required to view this report.

 

Workaround for this is to pass parameter as: =Format(DateAdd("d",(Parameters!param_days.Value * -1),Today()), "yyyy-MM-dd")

 

And change query to:

where

  error_date >= ?

 

Please fix the issue so that the multiplication of parameter is valid VQL/SQL and doesnt fail when published on the service.

Status: Accepted

As the document mentioned, it is a known issue that you can use the workaround to solve it. If there is any news or features about it, will update here as soon as possible.

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Accepted

As the document mentioned, it is a known issue that you can use the workaround to solve it. If there is any news or features about it, will update here as soon as possible.

 

Best Regards,
Community Support Team _ Yingjie Li