Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
gerrysulp
Frequent Visitor

Dynamics Business Central data model and Dimension Set ID

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

 

1 REPLY 1
Fowmy
Super User
Super User

@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.


 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.