Unanswered

Dataflow error on refresh but no errors showing in query data view

(0) Share

Report

Posted on by rlambe

I have been using power query in Excel and Power BI for some time. I am now trying to automate a sequence of queries with Dataflow in power apps. I can connect to my data sources and have been replicating the power queries that work in legacy Excel and Power BI files, but I get a "Unexpected exception" after I publish, during the refresh of the interim dataverse tables. I seem to get these when trying to replace blank values in selected fields with default values. Is there a different way to do this in Dataflow than the legacy power query?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Sebastian030 86 on at

Like (0)

Report
Copy link

Link copied!

Hello rlambe,

ive experienced that error in connection to datatypes.
Sometimes when im adding data to a new dataverse table by using a cloudflow, the datatypes from the dataverse table gets messed up.

Decimal values are getting interpreted as floats, the dataverse column is created with "float", but the flow results in decimal.
I solved this problem by
- checking the dataverse table columns datatypes
- delete the float ones
- recreate the float ones as decimal with exact name
- re run the flow

Was this reply helpful? Yes No
rlambe 2 on at

Like (0)

Report
Copy link

Link copied!

My problem does not seem to be the data types, it is with interim queries (not table fields) and telling me a column does not exist when I create it with a column pivot. The same interim query runs ok in a different dataflow (copied/pasted the code) which is why I am puzzled.

Was this reply helpful? Yes No