Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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! 🙂
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |