Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Missing column from business central table.

Hi;

 

I have a problem when I make the conneciton between Business Central and Power BI Desktop using the local connector; The problem is that in Power BI I can't see the full columns that I have in business central table.

How I could solve it?

 

Thanks in advance.

 

 

Regards.

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

Which connector do you use in power bi desktop?

In addition, what do you mean that can't see the full columns?

If it is convenient, could you share the screenshot to describe your scenario better so that we could help further on it?

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I'm using this connector:bc.JPGThe fild that I want to see in power bi is:

BC Description.JPG

 

But when I import the table that contains all this fields I can't see the description field:

bc pbi.png

 

Thanks in advanced.

 

Hi @Anonymous ,

Is the description field you created in dynamics 365 or the default column?

You could try to get the Dynamics 365 bussiness central app in power bi service and go to the related, then you could see the dataset to check if there is the description column.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Is a default column.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.