Forum Discussion

BKnecht's avatar
BKnecht
Kudo 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
Advocate 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:

  • fenixen's avatar
    fenixen
    Advocate II
    9 years ago

    EDIT:  I recreated the calendar table in power bi desktop, built everything identical, works fine. 

    The difference is that the old one was converted from a excel file.. 

     

     

     

    This did not work for me. I get the error on my calendar table and a autogenerated calendar doesn't have any blanks of course. 

    The report works just fine in power bi desktop, but when refreshing online in powerbi.com i get the error.. strange.. 

     

    Error message: http://imgur.com/a/ZonnT

    Data model: http://imgur.com/a/Kixyw  

     

    Just to really confirm to you guys that i don't have blanks: The calendar table has 366 rows, which is correct for a 2016 table. 

    I double checked that the "Many" side of the relationships dont have blanks either. 

    I even added the "remove empty" on the columns, even though there were no blanks. Same error. 

     

    Could it be some sort of location/locale bug in power bi on web? (norwegian)

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

     

    Thank you!