Fields are missing in a table in PBI

[Anonymous]

Hi Experts

I have few Access DB tables on the power bi desktop. One of the table is not showing couple of fields such as product hierarchy 1 & 2 but the same is available on the table in Access DB.

I cannot afford to delete the existing table in PBI as we have built some logic on it including form formulas. I'm looking to include the missing or removed fields which are there in the original table but not sure how to active this.

Please can someone provide your exert advise.

Thanks

Mahad

[Anonymous · Accepted solution]

Thanks for your reply.

Under the power query editor on the applied steps window, some of the fields were hidden which is why the fields were not populating. i removed them and they are appearing now.

Thank you.

Mahad

[PC2790]

Hey @Anonymous ,

Have you checked the Power Query?

Check the 1st step which is the source step in Power Query which would show you the extraction of data from AccessDB.

See if there is any column missing there which you might need to add.

Also try refreshing the preview to load all the columns.

If this doesn't work out, please share the Power Query Applied steps to further look into it.

Thanks