Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
I was ready to have my associates review my Power BI report and the last thing I needed to do was switch to import mode. After switching my duration function is now throwing a data type error. It works completley fine when on mixed mode but when it is in full import mode It gives me an error. I understand the error is that I am trying to use a string in a fixed decimal data type equation, but I do not understand why import mode would cause this.
I have spent way to long trying to figure out how to get this column to work and am basically out of ideas for it to do exctly what I want besides this script. I have reached out to my organizations internal Power BI team and even they are stumped.
Any feedback would be appreciated.
SCRIPT
Solved! Go to Solution.
@cmiller1221 , I doubt your datatype of the fixed decimal number.
For sum of duration refer to these
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
@cmiller1221 , I doubt your datatype of the fixed decimal number.
For sum of duration refer to these
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
@amitchandak None of the links fit except the last one which worked perfectly!! Thank you so much!
Can you verify that the data types as seen in Power Query or Import Mode are EXACTLY the same as they were when it was in Direct Query mode? Don't just assume by looking at the data in the Desktop, you need to note the data type(s) in Power Query.
Does the issue go away if you revert back to Direct Query?
Proud to be a Super User! | |
Thanks for the quick reply.
I just triple checked again and everything is exactly the same. The custom column is identical and so is everything in Power Query.
I do not believe you can revert back to direct query, but I have one file on direct and one file on import that are identical except for that. The direct query works and the import does not.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |