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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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?
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 12 | |
| 6 | |
| 5 | |
| 5 | |
| 5 |