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,
I have been receiving "Cannot convert value Null to type number " error for a column of my postgres database connected to Power BI. I have tried using all the solutions available in the community by "Replacing errors with null" etc.. . The column contains numbers however an average of 'NaN' is showed when plotted on the visual board. Can't get rid of it. Please help!
Solved! Go to Solution.
Hi Vivek,
I was able to solve the issue temporarily . I had connected the tables using the SQL code in PowerBI previously and the joined results had many errors and issues. I eventually used the 'Model' tab in PowerBI dektop app and mapped the relationships between each table. Post linking all the tables, I sorted the values in descending order for the column "scheduleddurationmins" and removed the topn 'NaN' rows. I am now able to visualize the column and get a numeric value rather than 'NaN on my dashboard. However, I don't know if this is the best solution or a permanent one. Thanks for all the help btw.
Cheers! 🙂
Hi Vivek,
The particular column I'm concerned about is having 'Decimal' values and I have tried bringing in the results using joins available in powerBI and tried another alternative where I joined them using the relationships tab. Howver, both of them don't solve my 'NaN'/Error value issue in that particular column.
Thanks
Hey Vivraan,
Apologies for the late reply. Please find the screenshots below. When I try plotting "scheduleddurationmins" , it shows as 'NAN'.
Hi Vivek,
I was able to solve the issue temporarily . I had connected the tables using the SQL code in PowerBI previously and the joined results had many errors and issues. I eventually used the 'Model' tab in PowerBI dektop app and mapped the relationships between each table. Post linking all the tables, I sorted the values in descending order for the column "scheduleddurationmins" and removed the topn 'NaN' rows. I am now able to visualize the column and get a numeric value rather than 'NaN on my dashboard. However, I don't know if this is the best solution or a permanent one. Thanks for all the help btw.
Cheers! 🙂
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 |
---|---|
113 | |
97 | |
85 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |