Errors Recurring Upon Refresh

[julie_bunavicz]

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 Power Query.  They pop up again after I close/open and refresh the dataset.

Any insight or advise on the topic is much appriciated.

Refresh
11 queries are blocked by the following errors:

--errors listed

Kind regards,

Julie Bunavicz

[PijushRoy · Accepted solution]

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