Forum Discussion

ankush-vem's avatar
ankush-vem
Frequent Visitor
5 years ago

Loading data from Business Central

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...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
5 years ago

Hi ankush-vem ,

 

how are you connecting the Busiess Central to Power BI?

Using Odata? 

  • ankush-vem's avatar
    ankush-vem
    Frequent Visitor
    5 years ago

    I have connected to Get Data > Online Services > Dynamics 365 Business Central.

    • v-kkf-msft's avatar
      v-kkf-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      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.

      • ankush-vem's avatar
        ankush-vem
        Frequent Visitor
        5 years ago

        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.