Refresh Error

[user900]

I refreshed a dashboard using Desktop, and it worked as expected.  I upload to Service and need to refresh again.  I am getting this error:  

Column 'ID' in Table 'Data' 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. (ID (4496)). Table: Data.

What does this mean and how can I fix it?  Need detailed steps on how to fix.

Thanks in advance

~user 900

[Anonymous]

Hi @user900 ,

As the error message says, please check if there are indeed blank values in the columns on the side of the many-to-one relationship or in the columns used as the primary key of the table, and if there are, please delete them or replace them with other meaningful values.
You can refer to this document:
Solved: Error contain blanks value in column on one side o... - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[user900 · Accepted solution]

Thank you for the suggestion.  After verifying there were no blanks, I reviewed the One Drive Refresh and Sync settings on the model of my dashboard which were turned off.  After turning them both on, the dashboard refreshed as expected.