You’re offline. This is a read only version of the page.
2
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?
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.
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
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
