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 this error when I try to load my dashboard that I have been loading for the past year with no problems but all of a sudden I get this error. The only thing I did differently this time was I had to import it into Excel from a CSV file because it was 270k rows and it wouldnt load more than 80k from a tab delimited file. Can anyone tell me what I can do to resolve this error message? This dashboard is critical and I have been researching and troubleshoting but have not been able to find any solutions. Thank you for your help.
Solved! Go to Solution.
It seems that some of the values can not be converted to decimal. Add a calculated column to have a check.
Column = ISERROR ( VALUE ( Table1[Column1] ) )
I went into the query editor and removed the changed type and that eliminated that error for now but now I am getting the error The function SUM cannot work with vaues of type String. ????
It seems that some of the values can not be converted to decimal. Add a calculated column to have a check.
Column = ISERROR ( VALUE ( Table1[Column1] ) )
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 |
---|---|
111 | |
97 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |