Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi,
I am using the load from SQL table option in Power BI. I have a table of customers with their addresses and the geocodes for those addresses. When I load the table, all of the coluumns are loading fine except the geocodes, lat/lon fields.
These, and only these, are loading as null. The fields are defined as Float. The data shows up fine when I view it in SSMS.
any ideas? Is it a problem with the Float type?
Thanks!
Do these columns already load as blank in Power Query? Maybe show your (sanitized) query code?