Loading data from Business Central

Question

Hi Team,I'm facing an issue while loading data from Business Central to PowerBI. Once I load the data, there are quite a few columns which are present in Business Central but not present in PowerBI.&nbsp;Could I get some help in fixing this issue?&nbsp;Thanks

mussaenda · Answer

Hi ankush-vem ,
&nbsp;
how are you connecting the Busiess Central to Power BI?
Using Odata?&nbsp;

ankush-vem · Answer

I have connected to Get Data &gt; Online Services &gt; Dynamics 365 Business Central.

v-kkf-msft · Answer

Hi&nbsp;ankush-vem&nbsp;,
&nbsp;
Go to Power Query Editor in order to see they were included (can then Expand the column to include portions needed).&nbsp;
&nbsp;
If&nbsp;those columns which are not present in PowerBI are custom fields in Business Central, you can refer to the following post to import custom fields.
&nbsp;
Add Customized Field Options to Power BI's Dynamics 365 Sales Template&nbsp;
Measure Your Custom CRM Fields Using Microsoft's Power BI Template&nbsp;
PowerBI Deep Dive: Using the Web API to Query Dynamics CRM/365 for Enterprise&nbsp;
&nbsp;
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ankush-vem · Answer

Hi&nbsp;v-kkf-msft&nbsp;,So when I connected to the Production environment of Business Central to Power BI, it shows only 30 columns when I load the data. Whereas when I check for the same table in Business Central, there are 44 columns. Some of the missing columns are the key to the reports and without them I can't get started to work on them. When I look at the preview of the table it mentions "The data in the preview has been truncated due to size limits".Also, when I previously used the Sandbox environment I was able to load all of the 44 columns.&nbsp;

v-kkf-msft · Answer

Hi&nbsp;ankush-vem&nbsp;,
&nbsp;
what you see in the Navigator is an info more than an error: we are simply informing the user that the table shown inside the navigator is a preview of the whole data-set. To see the full table you have to either Edit of Load the database.&nbsp;
&nbsp;

&nbsp;
Are the unloaded columns some custom columns of Business Center? Power BI cannot import custom columns using the Dynamics 365 Business Central connector, so you need to try other methods. You could check if the link I posted in the previous reply is helpful.
&nbsp;
&nbsp;
Best Regards,Winniz

Forum Discussion

Loading data from Business Central

6 Replies

Related content

Load Large data from business central

Business Central and Power BI loading data

CANNOT connect to Dynamics 365 Business Central

How to connect Business Central Financial Reports to Power BI

Setup Lakehouse with Business Central