Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

paul_barnabas

Data Gateway Refresh errors

Submitted by on ‎06-06-2019 08:10 AM

I keep getting the below error when I try to run an on demand or scheduled refresh. Kindly note that the mentioned error has been cross checked on multiple occasions to ensure that their are no blank values on either ends of the relationship and the both have the same data type. Kindly help!

"Column 'Region Code' in Table 'DIM-Region' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: DIM-Region."

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎06-06-2019 08:36 PM

Hi @paul_barnabas, 

 

Please open the report in Power BI desktop, go to Query Editor, find the column 'Region Code' in Table 'DIM-Region', remove blank values in this column, then apply the changes to data model.

 

Click on Refresh button to ensure refresh can be completed successfully, then republish the report to Power BI service. 

 

Best Regards,
Qiuyun Yu 

Idea Statuses