Forum Discussion
Column Data type
I am getting data from web in table form , which contains various types of columns with different data types like text, id,date etc . So is there any way that power bi can take data in that data type only ?
It shoud identify that this is id column or date column rather than showing text data type every time.
Generally it tries to identify the correct data type but sometimes it cannot or makes a mistake if the first few thousand rows are one type and then a different type gets thrown in later. This usually works very well but could understand that this may not work well for web.
You can always just change the type, right-click change type.
Anonymous , if it does not detect automatically try this option
https://www.thebiccountant.com/2020/05/01/detect-change-types-of-all-columns-in-power-query/
2 Replies
Generally it tries to identify the correct data type but sometimes it cannot or makes a mistake if the first few thousand rows are one type and then a different type gets thrown in later. This usually works very well but could understand that this may not work well for web.
You can always just change the type, right-click change type.
Anonymous , if it does not detect automatically try this option
https://www.thebiccountant.com/2020/05/01/detect-change-types-of-all-columns-in-power-query/