Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a duration column in excel, what data type should i use when import into power bi? it's all 'Error' when i select 'duration' in power bi.
Solved! Go to Solution.
Hi there, you would have to change it to Text, due to it having the ":" which is seen as text.
What I would suggest is if you want to calculate the duration in Power BI is to have the Source Date Time in order to do this, can modify it all to be seconds. Then from there you can then roll it up to Hours, Days etc.
Here is another link referencing how they did it with Date and Times
http://community.powerbi.com/t5/Desktop/Sum-of-H-MM-SS/m-p/124007
Hi there, you would have to change it to Text, due to it having the ":" which is seen as text.
What I would suggest is if you want to calculate the duration in Power BI is to have the Source Date Time in order to do this, can modify it all to be seconds. Then from there you can then roll it up to Hours, Days etc.
Here is another link referencing how they did it with Date and Times
http://community.powerbi.com/t5/Desktop/Sum-of-H-MM-SS/m-p/124007
Your link is invalid.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 46 | |
| 42 | |
| 34 | |
| 31 | |
| 21 |
| User | Count |
|---|---|
| 143 | |
| 125 | |
| 100 | |
| 81 | |
| 63 |