Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |