Forum Discussion
Loading data from Business Central
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