Missing data on Power Bi Service after successful …

Issue: Missing data on Power Bi Service after successful refresh

Error : Blank column

Resolution:

• We have created a test report connecting to the datasource(Azure SQL DB) and selected only one View which is appearing blank once the refresh is done on workspace.
• We have refreshed the report on Desktop and published it on Service on Workspace and refreshed but we have observed that the issue appears on test report as well.
• The column was blank and other columns were fine, hence we have checked the datatype of the column on datasource.
• We have identified that Parent table has Float as a datatype but View has NVARCHAR on View which is created on Datasource Azure SQL DB.
• On Power BI Desktop it was text column as the view as NVARCHAR datatype.

• So we have changed the type of the column to decimal value on Desktop and published to the Service.
• We tried On demand refresh and the report was working fine.
• We have also scheduled refresh for twice on test report and everything is working on test report.

Author: Nithya Mallapu

Reviewer: Mounika Narayana Reddy