Replaces the previous value.

Anonymous · ‎06-16-2023

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.

PhilipTreacy · ‎06-19-2023

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

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

PhilipTreacy · ‎06-16-2023

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

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

Anonymous · ‎06-16-2023

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