Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Replaces the previous value.

Hi All,

 

In DB, can see the null/Black cell values but when i import the data in power bi level it replaces the previous value automatically.

Exam: In DB, record 4 and 5 are blank but in power bi level it updates automatically previous value means Record 3 value.

DB Value:

In Power BI:

Could you please provide any inputs to avoid this senorio.

Thank you in advance.

 

Need Help

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous 

     

    Not sure how that could happen.  If the value is null/blank then PBI should be importing as that.

     

    Need to see your file/query to understand what is happening.

     

    Regards

     

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you so much for response.

      Below query used to import the data:

       

      SELECT r.STORE, r.STOCK, r.MODEL, r.SERIAL, r.RECIEVED, r.DESCRIPTION,
      r.CONTRACT, r.CUSTOMER, r.ACCOUNT, r.DEALER, r.DEPRECIATION, r.RBVBOOK,
      r.COST, r.CUR_STATUS, r.CO_NAME, r.INITIALS, r.S_NAME
      FROM VW_RPT_INV_ADD r

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous 

     

    That's just a basic SELECT so can't be altering the data, there must be something else going on.

     

    Why are you using SQL to get the data?  Can you use one of the built in DB connectors and use Power Query, without using SQL?

     

    Regards

     

    Phil