I am creating a Paginated report to use in a Power BI Dashboard based on a Published Paower BI dataset. Using a string based parameter works nicely however I am trying to add a date range tot he report as well. The database is based on a CDS imported table with a DateTime field. The field is recognised in PowerApps and in Power BI query as a datetime field however when trying to add it to a paginated report in report builder it appears to be recognising it as a string. I get the error "The property 'ValidValues' of report parameter 'FromTransactionsipmdate' doesn't have the expected type." when I try to run the report. The query builder added the following with the italics section being added for the date range parameters and the rest being the original query. The parameters were also added as you would expect and they were added correctly as date parameters.
DEFINE VAR vFromTransactionsipmdate1 = IF(PATHLENGTH(@FromTransactionsipmdate) = 1, IF(@FromTransactionsipmdate <> "", @FromTransactionsipmdate, BLANK()), IF(PATHITEM(@FromTransactionsipmdate, 2) <> "", PATHITEM(@FromTransactionsipmdate, 2), BLANK()))
VAR vFromTransactionsipmdate1ALL = PATHLENGTH(@FromTransactionsipmdate) > 1 && PATHITEM(@FromTransactionsipmdate, 1, 1) < 1
VAR vToTransactionsipmdate1 = IF(PATHLENGTH(@ToTransactionsipmdate) = 1, IF(@ToTransactionsipmdate <> "", @ToTransactionsipmdate, BLANK()), IF(PATHITEM(@ToTransactionsipmdate, 2) <> "", PATHITEM(@ToTransactionsipmdate, 2), BLANK()))
VAR vToTransactionsipmdate1ALL = PATHLENGTH(@ToTransactionsipmdate) > 1 && PATHITEM(@ToTransactionsipmdate, 1, 1) < 1
EVALUATE SUMMARIZECOLUMNS('Transactions'[ipm_jobidname], 'Transactions'[ipm_jobtask.ipm_code], 'Transactions'[ipm_jobtask.ipm_grouptaskidname], 'Transactions'[ipm_jobtaskidname], 'Transactions'[ipm_name], 'Transactions'[ipm_parentnumber], 'Transactions'[ipm_resourceidname], 'Transactions'[ipm_vendoridname], 'Transactions'[ipm_amount], 'Transactions'[ipm_date], RSCustomDaxFilter(@Transactionsipmjobid,EqualToCondition,[Transactions].[ipm_jobid],String), FILTER(VALUES('Transactions'[ipm_date]), (vFromTransactionsipmdate1ALL || 'Transactions'[ipm_date] >= DATEVALUE(vFromTransactionsipmdate1) + TIMEVALUE(vFromTransactionsipmdate1)) && (vToTransactionsipmdate1ALL || 'Transactions'[ipm_date] <= DATEVALUE(vToTransactionsipmdate1) + TIMEVALUE(vToTransactionsipmdate1))), "MatCost", [MatCost], "LabCost", [LabCost], "PltCost", [PltCost], "SubCost", [SubCost], "OthCost", [OthCost])
Any assistance would be appreciated.
