Forum Discussion
Read Approvals and Approval Request tables
Hi Folks,
I'm trying to read the Approvals and Approval Request tables using Power Bi, but I'm getting the below error message.
Here's the completed error message:
DataSource.Error: Microsoft SQL: Adding a value to a 'datetime' column caused an overflow.
RequestId: TDS;0fb7c282-c2ed-485c-aa9e-14cdad79349b;2
Time: 2021-04-05T14:12:27.3140958Z
Detalles:
DataSourceKind=CommonDataService
DataSourcePath=XXXXXXXXXXX.crm.dynamics.com
Message=Adding a value to a 'datetime' column caused an overflow.
RequestId: TDS;0fb7c282-c2ed-485c-aa9e-14cdad79349b;2
Time: 2021-04-05T14:12:27.3140958Z
ErrorCode=-2146232060
Number=40000
Class=16
it's worth mention that I'm getting the same error for the Approval Request table as well, but I can read the Approval Response table.
I don't know if there is a way to read the tables using "normal" SQL sentences, on where I can pick only a few fields and avoid the error with the date?
Thank in advance for any idea!!
2 Replies
- Icey
Community Support
Hi diegoadum ,
Please check if the datetime value falls within the range from 1753 to 9999.
Reference:
sql server - "Adding a value to a 'datetime' column caused an overflow." - Stack Overflow;
sql - Adding a value to a datetime column caused an overflow - Stack Overflow.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Icey
Community Support