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?

      • khaled_cs's avatar
        khaled_cs
        Frequent Visitor
        9 years ago

        yes 
        please check this doc https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/process-database-table-or-partition-analysis-services 

        this will be answer for the following case 

        if you get this error message "Table contains blank values"
        you cleared your database and make sure there is no empty/blank values in your database 

        but everytime you try to run you get this issue 

        the meta data of the DB need to be refreshed 

        you can update the whole DB or just the table you are working on 

         

        To process a database

        1. In SQL Server Management Studio, right-click on the database you want to process, and then click Process Database.

        2. In the Process Database dialog box, in the Mode listbox, select one of the following process modes:

          Mode Description
          Process DefaultDetects the process state of database objects, and performs processing necessary to deliver unprocessed or partially processed objects to a fully processed state. Data for empty tables and partitions is loaded; hierarchies, calculated columns, and relationships are built or rebuilt (recalculated).
          Process FullProcesses a database and all the objects that it contains. When Process Full is run for an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object. This option requires the most resources.
          Process ClearRemoves all data from database objects.
          Process RecalcUpdates and recalculates hierarchies, relationships, and calculated columns.

        3. In the Process checkbox column, select the partitions you want to process with the selected mode, and then click Ok.