Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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 |
|---|---|
| 13 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |