Forum Discussion
Loading data from Business Central
I have connected to Get Data > Online Services > Dynamics 365 Business Central.
Hi ankush-vem ,
Go to Power Query Editor in order to see they were included (can then Expand the column to include portions needed).
If 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.
Add Customized Field Options to Power BI's Dynamics 365 Sales Template
Measure Your Custom CRM Fields Using Microsoft's Power BI Template
PowerBI Deep Dive: Using the Web API to Query Dynamics CRM/365 for Enterprise
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.
Hi v-kkf-msft ,
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.Hi ankush-vem ,
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.
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.
Best Regards,
Winniz