The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
Airtable to PowerBi Number Transfer
Hi,
I currently have three Single Select columns from Airtable going into a PowerBi report. I noticed that my age column is numerically in order but my other two columns are not.
At first, the other two columns were number columns and the age column was a single select column. I have now updated the other two columns to be single select but this doesn’t fix my issue.
Somehow, PowerBi sees the 3 numbers coming in from Airtable as 10,4.5 even though Airtable is correct 4.5.10.
I have tried to add new columns in Airtable and start over in PowerBi but nothing has worked yet. Any thoughts?
The column in Airtable.
This is the Customize menu for the column.
PowerBi
Here is the correct Age column in both Airtable and PowerBi.
