Forum Discussion

BKnecht's avatar
BKnecht
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

Error on Scheduled Refresh: Table contains blank values

I have a dashboard scheduled to refresh daily, but each time I get an error that says:   "Column in Table contains blank values and this is not allowed for columns on the one side of many-to-one re...
vprady's avatar
vprady
Icon for Advocate I rankAdvocate I
10 years ago

 

I found on the PowerBI desktop application

 

1. Click on "Edit Queries" 

 

 

 

 

 

 

Step 2 - Select the table that has the error.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 3 - Select column which gives the error and in drop down filter select "Remove Empty" 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click Close and Apply and Refresh again.

 

This solved my problem and addressed all my refresh errors through this.

 

Excuse for any typos or errors, this is first time i am posting a solution, I am usually on the other end, but for this realized there are many people like me. :smileyhappy:

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I was getting the same error message - this solution worked for me.

 

Thank you!