Forum Discussion
Invalid OADate value error
I createded a dashboard using source data in a csv format. Now I connected the PBI dashboard to Table Storage in Azure. Basically this works fine but when I want to add a measure in a PBI table I get...
Your shared information is too simple for us to troubleshoot your issue. Could you please share us more detailed information like your the measure you added or some screenshots about your report if possible?
By the way, I have found a relevant thread. Hope it helps:
https://community.powerbi.com/t5/Desktop/Invalid-OADATE-Value/td-p/155073
Thanks,
Xi Jin.
v-xjiin-msft, thanks for your response.
I figured it out. In Edit Query I set the date/time format manually. That created the issue when using the measure.
I deleted the database and uploaded it again and instaed of manually set the date/time format I used "detect data type" to format the date field. That solved the issue.
Regards,
Tairo