Solved: Errors Recurring Upon Refresh

julie_bunavicz · ‎10-30-2023

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 · ‎10-30-2023

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

Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!

View solution in original post

PijushRoy · ‎10-30-2023

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