Answered

Reason: Bad Request, Error code: 0x80044330

(0) Share

Report

Posted on by nina_tang

When I tried to import data from Power Platform dataflows to Power app, I failed. Got an error message as the following.

Reason: Bad Request, Error code: 0x80044330, Message: A validation error occurred for {column name}. The value -2352509.89239204 of type System.Double is outside the valid range(0 to 1000000000)

As I know, the double type has more larger range beyond this(0 to 1000000000). If this is the limitation of the number of power app, how can I display the negative number?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @nina_tang ,

Based on the issue that you mentioned, it seems that there is something wrong with the value you provided within the {column name} in your data source, which is outside the valid range (0 to 1000000000) of the System.Double type.

If you want the column in your CDS Entity to store the negative number, I think the Decimal Number Type could achieve your needs. The Decimal Number Type has a valid range between -100,000,000,000 and -100,000,000,000.

https://docs.microsoft.com/en-us/powerapps/developer/component-framework/manifest-schema-reference/type#value-element

On your side, you could consider change Whole Number type/Floating Point Number type in your CDS Entity into Decimal Number Type, then you could store the negative number in your CDS Entity.

Best regards,

Was this reply helpful? Yes No
nina_tang 4 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-xida-msft

I had chosen "decimal number" in my power query editor, but still got the same problem.

This is my queries
let Source = PowerPlatform.Dataflows(null), Navigation = Source{[Id = "Workspaces"]}[Data], #"Navigation 1" = Navigation{[workspaceId = ""]}[Data], #"Navigation 2" = #"Navigation 1"{[dataflowId = ""]}[Data], #"Navigation 3" = #"Navigation 2"{[entity = "Gap"]}[Data], #"Changed column type 1" = Table.TransformColumnTypes(#"Navigation 3", {{"operating_income_gap", type number}}) in #"Changed column type 1"

And this is the model.json I defined in CDM folder.
{ "name": "RatioToRevenue", "description": "", "version": "1.0", "entities": [ { "name": "RatioToRevenue", "description": "", "$type": "LocalEntity", "attributes": [ { "name": "bg", "dataType": "string" }, { "name": "site", "dataType": "string" }, { "name": "product", "dataType": "string" }, { "name": "type", "dataType": "string" }, { "name": "reportingMonth", "dataType": "string" }, { "name": "operating_income_ratio", "dataType": "double" }, { "name": "moh_ratio", "dataType": "double" }, { "name": "material_cost_ratio", "dataType": "double" }, { "name": "other_cost_ratio", "dataType": "double" }, { "name": "opex_ratio", "dataType": "double" }, { "name": "gross_revenue_ratio", "dataType": "double" } ], "partitions": [ { "name": "RatioToRevenue0", "location": "", "refreshTime": "2020-03-19T08:56:27.293Z" } ] }, ] }

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @nina_tang ,

Do you change the date type of the corresponding field in your CDS Entity into Decimal Number type?

Please make sure you have changed the corresponding field in your CDS Entity into Decimal Number type rather than within Power Query Editor.

In addition, if you want to load data into your existing CDS Entity, I think it is not necessary to set up a dataflow. Please take a try with the "Get data" option within CDS Entity:

then check if the issue is solved.

Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-cds-newentity-pq

Best regards,

Was this reply helpful? Yes No