Share this article

Improve this guide

Column Contains Blank Values [Power BI Error Fixed]

3 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

Power BI Service and theDesktop clientallows the users to have a dashboard scheduled to refresh daily using the table.

If you happen to have any blank rows in the table, you may seeColumn contains blank values and this is not allowed many-to-one relationship.

Several Power BI users have reported a similarerrorin thePower BI Community forum.

I have a dashboard scheduled to refresh daily, but each time I get anerrorthat says:Column in Table contains blank values and this is not allowed for columns on the one side of many-to-one relatioship for coulmns that are used as the primary key of a table.I went to this table and edited the query to Remove Blank Rows, but I still get theerrorevery time I try to refresh thedata.

Follow the steps listed in this article to troubleshoot thiserrorin Power BI service and desktop client.

How can I fix the power BI error blank values?

1. Delete Invalid Relationship Between Data Sets

2. Disable Include Relationship Columns Option

3. Other Solutions to Try

Tashreef Shareef

Tashreef Shareef is a software developer turned tech writer. He discovered his interest in technology after reading a tech magazine accidentally. Now he writes about everything tech from Windows to iOS and streaming services to IoT at WindowsReport.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Δ

Tashreef Shareef