Forum Discussion
Value null to type number error with postgres database
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! :)
Thank you for sharing the screenshot, however it is not helping much.
I wanted to understand the column property in the PowerQuery window as the issue primarily lies there. Not able to figure out anything from Power BI data view.
Following might help:
# Copy the column value in an Excel file and share
# Screenshot of Power Query window with the column property in view of this column (screenshot of the error fields may also help)
# If there are any Error table created in the Power Query, then export of that (if possible)
Rgds,
Vivek
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! :)