Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
2 years ago

IDATAREADER INTERFACE ERROR NULL INDENTIFIER

Delete the error causing column and reload the table replacing null values with 0.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi BIswajit_Das ,

    Please try:
    1. Make sure the data types of both the fields in a relationship are same.
    2. Replace (null) values with 0 for decimal or whole number data types.
    Power BI Error : “The exception was raised by IDataReader interface.” – Rohit Vangala (wordpress.com)


    If you're still encountering issues after trying these steps, could you please provide more details about your scenario? Specifically:
    What database or data source are you working with?
    Can you share a snippet of the code where the error occurs, especially around the IDataReader usage?
    What is the exact error message you're receiving?

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual

    Hello Anonymous  thanks for responding but i've tried both but didn't found what is the origin of the error in the data set.

    --> There's no null values replaced with 0

    --> Is blank cells count as null values ?