Forum Discussion
Error on Scheduled Refresh: Table contains blank values
Hi, what do you mean by process clear?
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
- erantdo9 years agoFrequent Visitor
Hi, I'm connecting to a MySQL server, installed on an AWS instance. Is what you said relevant to my case?
- khaled_cs9 years agoFrequent Visitor
yes
please check this doc https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/process-database-table-or-partition-analysis-servicesthis 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 databasebut 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
In SQL Server Management Studio, right-click on the database you want to process, and then click Process Database.
In the Process Database dialog box, in the Mode listbox, select one of the following process modes:
Mode DescriptionProcess Default Detects 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 Full Processes 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 Clear Removes all data from database objects. Process Recalc Updates and recalculates hierarchies, relationships, and calculated columns. In the Process checkbox column, select the partitions you want to process with the selected mode, and then click Ok.
- elxaxe8 years ago
Advocate I
Hi,
Has anyone solved this?
I'm facing almost the same issue. Error message is: Column '' in Table '' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
But this is happening today as yestearday no issue happened. The calculated column that gives this error is calculated like this:
GOAL = LOOKUPVALUE(Services[GOAL]; Services[Case_ID]; Orders[Case_ID])
An GOAL needs to have null values (because newest services aren't estimated yet) and these null values are checked later.