Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group