Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
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
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |