Additional data feilds in the AssetTrans Table

(1) Share

Report

Posted on by OS-03071515-0

Hi,

We have a report setup on Power BI to bring back Fixed Asset Transactions, this looks at the AssetTrans Table.

In the last week 2 new data fields have been added to the AssetTrans table exported from D365 F&O, this has resulted in issues with the report. The additional data fields added are:

"PERIODFROMDATE"
"PERIODTODATE"

But I cant see these data fields in the Asset Transaction Form on D365 - My question is what is triggering these changes to the AssetTrans Table, I have checked there was nothing in patch update or quality update.

Also how can we keep track of changes to tables?

Any help will be appreicated

I have the same question (0)

All responses (4)

Answers (0)

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I'm not sure if I understand you issue correctly, but you use this table through Power BI, do you connect to power BI using data entity? also, when you said you don't see the fields data on Form, do you mean the fields aren't filled? or have not appeared on the form?

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
OS-03071515-0 12 on at

Like (1)

Report

Hi,

Sorry my post was a bit confusing.

Yes we use this table through Power BI & we connect via data entity.

The problem is 2 weeks ago it had 48 data fields, but it now has 50 data fields ("PERIODFROMDATE" "PERIODTODATE") I wanted to know what triggered this additional fields to appear?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you tell how you export the Asset transactions to Power BI? Are you using Export to Data Lake, BYOD, Synapse Link, Fabric link? Do you then export the table directly or details via a data entity?

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You said after adding those fields, you started having issues with the report, may i know what the issues are? Or do you mean thay u don't want these fields to appear in the report?

Was this reply helpful? Yes No