Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

monaraya
Employee
‎02-20-2021 10:44 PM

Missing data on Power Bi Service after successful refresh

Issue: Missing data on Power Bi Service after successful refresh

Error : Blank column

monaraya_0-1613889684813.png

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.

monaraya_1-1613889684818.png

 

  • 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

0