Forum Discussion

aqavi10's avatar
aqavi10
Advocate I
7 years ago
Solved

Value null to type number error with postgres database

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 comm...
Need Help
  • aqavi10's avatar
    aqavi10
    7 years ago

    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! :)