Solved: Blank Calculated Columns after refreshing SQL Data

Anonymous · ‎08-09-2022

After creating several calculated columns in the Data view and pulling data from several related tables, I ran a refresh from SQL for the most current data. After an apparently successful update, the calculated columns are now not returning any results. I am not reciveing any syntax errors on my formulas and the the SQL server path has not changed.

I also reviewed a possiblity related post but I do not appear to be encountering the same issue.

Calculated column looks correct on preview but blank on refresh (dataflow)

Anonymous · ‎08-15-2022

Hi @Anonymous ,

According to your statement, I think you are getting data from SQL Server by import connection mode. Your issue is that your calculated column will return blank after you refresh your report. Please check whether the columns you used in your calculation is still ok, maybe one of them have changed to 0 or blank in your calculation.

If this reply still couldn't help you solve your problem, please show me more details about your data model. I need to know your data format and your calculate logic.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous · ‎08-15-2022

Hi @Anonymous ,

According to your statement, I think you are getting data from SQL Server by import connection mode. Your issue is that your calculated column will return blank after you refresh your report. Please check whether the columns you used in your calculation is still ok, maybe one of them have changed to 0 or blank in your calculation.

If this reply still couldn't help you solve your problem, please show me more details about your data model. I need to know your data format and your calculate logic.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.