Dynamics Business Central data model and Dimension Set ID

gerrysulp — Fri, 27 May 2022 11:42:20 GMT

Hi,

I've been struggling with a topic any Dynamics Business Central + Power BI experts would probably laught about. Have googeled for different solutions but I'm not too experienced in Power BI to follow the description.

Can somebody link a simple tutorial or explain by steps how can I separate in Power BI data model Business Central datatable 'Dimension Set Entry' in a way I could use all dimensions separately as I can in Business Central? The need is to create financial data reports (actual costs vs. budget by dimensions) based on Business Central ledgers to be filtered by each dimension separately. I'm running on BC version 19, soon to be 20.

Really appreciate for help

Re: Dynamics Business Central data model and Dimension Set ID

Fowmy — Sun, 29 May 2022 10:58:24 GMT

@gerrysulp

I have developed Power BI solutions by connecting to Dynamics NAV for Financial and Sales reporting. It should be the same for BC 365 as well.
I accssed the SQL DB and table 349 | Dimension Value and filtered by Dimension Code for the required dimension and used as a table/query entitly in my model.

This approach was easier for me.

topic Re: Dynamics Business Central data model and Dimension Set ID in Developer

Dynamics Business Central data model and Dimension Set ID

Re: Dynamics Business Central data model and Dimension Set ID