Forum Discussion
rolling average by half hour
hi v-jiascu-msft
Here is the details :
it says :
Cannot load the data for this visual :
Converting the data type from "varchar" to "datetime" has created an off-limit value. The exception was triggered by the IDaraReader inferace.
Hi Ghaston,
Can you share your file? You can upload it to the cloud drive like OneDirve, GoogleDrive and then paste the download link here.
Best Regards,
Dale
here is the link to my file :
https://drive.google.com/open?id=1lHOTBAjdz5kurSLWpA5RoEydrD6NbKw5
But i'm nit sure if it willwork for your, because, i said before i'm using Direct Query. So the data are not imported into Power BI DesktopHi Ghaston,
That can't work. What's the type of column [Date_Heure]? Seems it isn't a DateTime type. Please check out. The error message is clear. We should check the data type and its values which should be a normal time. For example, 25: 30: 00 isn't a time.
Best Regards,
Dale
it's a date/time typeHi Ghaston,
The formula worked well in my test. Please refer to the snapshot below. Do you have any other details you can share?
Best Regards,
Dale
Well, i was trying to recreate the Dashbord in Import mode, so i can share it with you. And then, your code worked perfectly on the new Dashboard (import mode).
I don't know, why it didn't work on my Direct Query model, even though i'm using the same source file, and the data has the same type...Hi Ghaston,
Did you make it work? Do you use the latest version of Power BI Desktop?
Best Regards,
Dale