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...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super 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