Loading Data from Business Central

[harshaSampath81]

Hi,

I Loaded Data from Business Central to Power BI Desktop Example "Cronus" company  I saw After load data to Power BI Desktop there are few tables inside the power BI, So I want to know Can I load All the table as Navision Sql Table , and What are table start from Power BI (ex   Power_BI_Aged_Inventory_Chart, etc), and I saw there is Relationship among the table as well. How it comes with a relationship, as Navision table in sql there is no any relationship when we load table to Power BI desktop. Please anyone can explain to me how to load all the table in Business central, how we access all the table for getting all the data.

Thank you ,

Harsha

[v-qiuyu-msft]

Hi @harshaSampath81,

You can select all tables under the company then load them to Power BI desktop. Regarding the table which name starts with "Power BI", I would suggest you post a thread in Dynamics 365 Business Central Forum: https://community.dynamics.com/business/f/758

Regarding the relationship, please check if you already enabled these two options: 

Best Regards,
Qiuyun Yu