Forum Discussion
Detect data type on all columns in a template
Hi! I'm trying to create a template for a report and the final step in my query are 'Detect data type' on all my columns. Unfortunately our data won't always have the same column names, so when ...
Power Query should automatically detects data, and change data types based on the imported table, you should able to see the signs in front of the column names.
Paul Zheng _ Community Support Team
Hi,
Maybe because I did other steps prior, but it doesn't detect the data type and if I go back to the report, all the visuals are 'broken' because they didn't detect that it was a number for example.
Maybe, there is no workaround and just need to redo the step when creating a new report from my template.