web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : N6zt4ykQlYqxQyau9uL5j1
Power Apps - Microsoft Dataverse
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 7 Jul 2023 15:46:08 by 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?

Categories:
  • rlambe Profile Picture
    2 on 25 Jul 2023 at 12:30:47
    Re: Dataflow error on refresh but no errors showing in query data view

    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.

  • Sebastian030 Profile Picture
    86 on 25 Jul 2023 at 12:18:40
    Re: Dataflow error on refresh but no errors showing in query data view

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics