https://community.fabric.microsoft.com/t5/Report-Server/Error-on-DateDiff-function/m-p/849196#M12196 <P>Hello all.</P><P>&nbsp;</P><P>I deleted and reuploaded the PBI file and now it is working.</P> Mon, 18 Nov 2019 16:52:20 GMT Anonymous 2019-11-18T16:52:20Z https://community.fabric.microsoft.com/t5/Report-Server/Error-on-DateDiff-function/m-p/848919#M12187 <P>Hello all,</P><P>&nbsp;</P><P>I created a report using PowerBI Desktop and everything is workfine. When I upload it to PowerBI Report Server (on premises) I got an error on a specific column that uses the following function:</P><P>&nbsp;</P><LI-CODE lang="markup">RFCDaysOpen = DATEDIFF(RFC[Created],RFC[Modified],DAY)</LI-CODE><P>&nbsp;</P><P>All tabs uses the same datasource (CSV File), which is being loaded and updated successfully.</P><P>&nbsp;</P><P>Working on PBI Desktop:</P><P><img /></P><P>&nbsp;</P><P>Not working on PBI Report Server</P><P><img />&nbsp;</P><P>&nbsp;</P><P>Thanks</P> Mon, 18 Nov 2019 12:12:01 GMT https://community.fabric.microsoft.com/t5/Report-Server/Error-on-DateDiff-function/m-p/848919#M12187 Anonymous 2019-11-18T12:12:01Z https://community.fabric.microsoft.com/t5/Report-Server/Error-on-DateDiff-function/m-p/849196#M12196 <P>Hello all.</P><P>&nbsp;</P><P>I deleted and reuploaded the PBI file and now it is working.</P> Mon, 18 Nov 2019 16:52:20 GMT https://community.fabric.microsoft.com/t5/Report-Server/Error-on-DateDiff-function/m-p/849196#M12196 Anonymous 2019-11-18T16:52:20Z