Is anyone here familiar with connecting Power BI to Microsoft Dynamics Business Central? When using the Power BI Connector for BC I see, among some other tables, a view with lots of Power_BI_xxx tables.
Is there a data model available or a documentation what is Microsoft’s idea behind these tables?
What I need to get, with transformation in PowerQuery as needed, are fact tables e.g. revenue from sales or invoices, and dimensions, e.g. by product, customer, sales department, region,… What’s the smartest way to get these from BC?
I’ve attached a model that gets some basic data from BC to see what I’m looking for. But my impression is, that the BC Connector does not expose all data that I need or I simply don’t know where to find them. So I generated some of the dimension tables by summarizing other tables, although they must be in the database on their own somewhere. Pointing me to a good resource, documentation or video to get started with doing it the right way would already be very helpful.
Business Central Cloud SANDBOX CRONUS DE Connection English.pbix (325.0 KB)
Thanks a lot in advance!