cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pavanb
Frequent Visitor

Data Load Error - Numeric value shows up as Null - there is data in back end table

Hello,

I am loading a table from SSMS and I get all null values for a numeric column in my Power BI report.  

I create a new tab in this report and put this data in a new tile - still get null values for that numeric column.

When I create a new report and add this column, i see the correct numbers.  

Not sure what the issue is or how to get the correct numeric values in my first Power BI report.

I will greatly appreciate your suggestions.

Thanks!

Pav

1 REPLY 1
lbendlin
Super User
Super User

I am loading a table from SSMS

Do you mean from a SQL Server database table? Or via Export? or copy/paste?

Helpful resources

Announcements
March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Kudoed Authors