Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Has anyone else had this issue? My report wont refresh because
"Column 'BR_Site' in [Table] 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..."
And yet here, I have changed the "Key column" to the correct and proper PK. It still will not refresh without the same error! Where do I change the PK for the Table?
Is this just a bug in the latest version of Desktop? Has anyone else seen this issue? If I delete and re-import the table, then I'll lose all my measures & columns.
Ok, still not working. Something in PBI Desktop is "sticking" on an old relationship, even though it's been deleted. Data will not refresh. "Column 'ID' in Table 'SITE_BR_view' 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 (2501))." But this relationship is long gone. I hate to have to rebuild this entire report because of this bug.
Ok, latest hack: went in to Transform Data, DELETED the [ID] column that was causing this "ghost" relationship, and that allowed me to refresh the data and republish the report. Not only should I not have to do this, but I have little confidence that this will persist or permanantly solve the issue.
Yep, latest version of PBI appears to have a bug. I deleted the table, reinserted it, repasted all my measures and columns, and it refreshed normally. Someone should get on this. Designating, or redesignating a table/view PK does not appear to work consistently for direct import.