Forum Discussion

julie_bunavicz's avatar
julie_bunavicz
Frequent Visitor
2 years ago
Solved

Errors Recurring Upon Refresh

Hi,   I'm wondering if someone can help me understand why the same errors reoccur upon data refresh from Power BI?  I can resolve the errors fairly easily by refreshing each query independantly in ...
General Comment
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi julie_bunavicz 

    This is happened due to below
    1. Check all marge query (JOIN) in Power Query, each column datatype
    2. Check all Append query (UNION) in Power Query, each column datatype between UNION table
    3. Check the relationship in data model, delete all and recreate the relationship
    4. In relationship, datatype in the column should be same
    5. If you change the Datatype in Power BI desktop, but Power Query editor has other datatype

    May be this will help you. If yes give 👍 and if resolve your issue make as SOLUTION

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi julie_bunavicz 

This is happened due to below
1. Check all marge query (JOIN) in Power Query, each column datatype
2. Check all Append query (UNION) in Power Query, each column datatype between UNION table
3. Check the relationship in data model, delete all and recreate the relationship
4. In relationship, datatype in the column should be same
5. If you change the Datatype in Power BI desktop, but Power Query editor has other datatype

May be this will help you. If yes give 👍 and if resolve your issue make as SOLUTION