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.
Hi
My data source in google sheet and my data column like talk time
However, when I tried to connect to Power BI, I am getting this error. I tried to format the column in google sheet into duration and text but had no success
this is my original data in the google sheet
Error in Power BI
Please advise
Solved! Go to Solution.
One way to do that would be to convert that column to text type, and then add a custom column with this expression (returns days in decimal form). From there, convert that new column to decimal and load it. See this article for best practices on how to deal with durations from there.
Calculate and Format Durations in DAX – Hoosier BI
= let
inputlist = Text.Split([Duration], ":"),
numberlist = List.Transform(inputlist, each Number.FromText(_)),
minutes = numberlist{0} * 60 + numberlist{1} + numberlist{2}/60
in
minutes/(60*24)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@bourne2000 I think you need to create a duplicate column in Google Sheet that would be a text version of
[Wrap Up Time] and then you are going to get the text version of that column
One way to do that would be to convert that column to text type, and then add a custom column with this expression (returns days in decimal form). From there, convert that new column to decimal and load it. See this article for best practices on how to deal with durations from there.
Calculate and Format Durations in DAX – Hoosier BI
= let
inputlist = Text.Split([Duration], ":"),
numberlist = List.Transform(inputlist, each Number.FromText(_)),
minutes = numberlist{0} * 60 + numberlist{1} + numberlist{2}/60
in
minutes/(60*24)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |