Forum Discussion

jonj's avatar
jonj
New Member
5 years ago

Columns missing from Business Central Table

Can anyone shed any light as to why a table (Posted Credit Sales Memos) I'm connecting to from our Business Central on Premises would be missing a number of columns in PBI?  Some are existing and some are custom.  We are currently using BC version 13.1 so I'm wondering whether this may have anything to do with it?  Are there any dataset settings or permissions that are required for these to be picked up by PBI?  Or should i be able to invoke these from PBI?  I appreciate and am thankful for any help/suggestions in advance.

Need Help

1 Reply

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi jonj,

     

    Reconnect to the data source and try the following steps:

    1. Go to data view in power bi desktop by clicking on Data view on left hand side and check all data is there or not.
    2. Ensure correct data type has been applied in power bi desktop to each columns.

    If the issue was still exsit, please check your desktop version and provide more details about the issue.

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.