cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amnadeem1991 Regular Visitor
Regular Visitor

Error "column contains blank values and this is not allowed anyone relationship...."

Hi All, I am getting an Error "column contains blank values and this is not allowed many-to-one relationship....".

I have been using the same backend excel files on Powerbi Desktop since long, but never got such error while refreshing the data. I just made some changes in one of the two backend files and tried to "Refresh" the pbix. But it fails with above error. Surprisingly, the error says : There are blank cells in a column "Order". (see attached image). But when I went into the backend files and check the column "Order", it does not have any blank cell. All cells have some value. Also, I checked PowerBi "Manage Relationships". There is no relation available. 

Any suggestions for this problem? ThanksERROR.png

3 REPLIES 3
Jessica_Seiya Established Member
Established Member

Re: Error "column contains blank values and this is not allowed anyone relationship...."

Did you go to Power Query Editor to check if the column Order in the Table "Data Spend" contains any blank value? Sometimes, the blank value coulod be hidden on the source file but when loading it into Power BI, you can find this blank value shown as null in Query Editor

Highlighted
amnadeem1991 Regular Visitor
Regular Visitor

Re: Error "column contains blank values and this is not allowed anyone relationship...."

Yes I checked. I could not see any unsusual value or blank cell there. Please suggest if you want me to check that by some specific method. (I am not that much expert) 🙂
v-yulgu-msft Super Contributor
Super Contributor

Re: Error "column contains blank values and this is not allowed anyone relationship...."

Hi @amnadeem1991,

 

I have tested, if one column contains null value, it is still possible to establish a relationship based on this column. In your scenario, please go to relationship managements, check is there any automatically created relationship between very different queries pulling data from separate sources with similar column names. 

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 376 members 3,869 guests
Please welcome our newest community members: