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...
khaled_cs's avatar
khaled_cs
Frequent Visitor
9 years ago

I had the same issue I did process clear then recalc then  full 
and it works fine for me
because meta data has some old data so it does assume the empty value still there

 

  • erantdo's avatar
    erantdo
    Frequent Visitor
    9 years ago

    Hi, what do you mean by process clear?

    • khaled_cs's avatar
      khaled_cs
      Frequent Visitor
      9 years ago
      When you connect to SQL server management studio analysis services instance , right click and process your data base , you have some options of type of process you want to apply
      There you will find process clear
      Remember I fixed my data import and made sure no blank values imported
      Then I did apply process clear and recalculate
      Try it and let me know
      • erantdo's avatar
        erantdo
        Frequent Visitor
        9 years ago

        Hi, I'm connecting to a MySQL server, installed on an AWS instance. Is what you said relevant to my case?