Read Approvals and Approval Request tables

[diegoadum]

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!!

[Icey]

Hi @diegoadum ,

Can the content of my reply above help you solve the issue?

Best Regards,

Icey

[Icey]

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.