Inferring column types for a Table RRS feed

  • Question

  • When designing a query in PowerQuery the designer has some smarts that will insert the column type conversions automatically based on the data, like this:

        #"Typed" = Table.TransformColumnTypes(#"DataTable",{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Volume", Int64.Type}, {"Adj Close", type number}})

    I have a data query that isn't known until runtime so the returned data types aren't known either. But then there is no way to infer the column types at runtime. Is there a way to do:

    #"Typed" = Table.TransformColumnTypesInferFromData(#"DataTable")

    Saturday, May 30, 2015 9:50 PM


  • It's something we've thought about doing but isn't available today. One of the reasons it hasn't been that important is that refresh outside Excel (e.g. in the service) currently requires that the schema doesn't change -- so we'd effectively be giving you access to a function which we know we can't really support in cloud-based refresh.

    Monday, June 1, 2015 3:24 PM