Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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/
@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/
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |