Fixing Time Error Message : Wrong Data Type or the result is Too Large or Too Small in Power BI

How to fix function TIME has the wrong data type or the result is too large or too small

There is a solution to do this.... and we'll show you step by step in this Power BI tutorial video.

Kind regards,
Isabella Susilowati @LighthouseAnalytix
#powerbi_training , #powerbitips, #powerbitutorial, #powerbi

License code: 9B0RZZR9KSQR33Y1

LA 126

[priyal_]

Hi
I created a 'Time' table which has all the date, date/time, month, year, columns. I created the relationship between 'date' from the 'Time' table and 'date' from the another table. Although I have checked the data types and format and everything but due to some reasons my visuals don't show any data. When I end that relationship then, visual work properly. What could be the reason for that. It does not show any error so that I could know the reason. It is just that when I create a relationship, the visuals don't show anything, and gets blank.


In my case the data comes from SQL server

[thomassamoht]

pasti ada keturuan jawa hehehe..matur nuwun video2nya

[KartikChauhan-ngoe]

Is finance business analyst a good scope? For a candidate who like finance and curious about IT?

[ChinmayMokal]

Hi Isa, I tried doing average.

Part 1:
It works if you take card visual BUT doesn't if you take table visual. I have 9M+ rows.

Part 2:
I already have a column which gives me duration in HH:MM:SS with datatype as TIME. But it still doesn't show up on chart. Any solutions or links/references for this problem?


You are awesome! Thanks !!