I am working a project and attempting to use BI as my visualization tool. My data sets are very basic and require a few custom calculation fields. I created all my required fields in the query edit...
Possibly this is related to an issue I reported back in September 2016: when you provide a data type as the 4th parameter of the function Table.AddColumn, any data in the column that has another type, is still displayed in Query Editor, but it won't load into your tables.