cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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
Highlighted
Resident Rockstar
Resident Rockstar

Re: Missing column from business central table.

Hi @vsgarciap ,

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.
Highlighted
Helper II
Helper II

Re: Missing column from business central table.

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.

 

Highlighted
Resident Rockstar
Resident Rockstar

Re: Missing column from business central table.

Hi @vsgarciap ,

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.
Highlighted
Helper II
Helper II

Re: Missing column from business central table.

Is a default column.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors