Forum Discussion
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 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
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
1 Reply
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