We would like to be able to do reporting in PowerBi on Dimensions. Currently, the dimension set ID field from table 20 is not published on page 20 that we can publish to PowerBi.
This would make reporting much easier with Excel and PowerBi.
Comments
Can this please get pushed up. Dimensional reporting is one of the biggest benefits of BC and having dimensional data in PowerBI is critical. Having to work out how DimensionSetID's and DimensionSet work is way too complex. Having a simple webquery would save everyone a ton of effort.
Category: Reports and Business Intelligence
The dimension set ID field has been made available on almost all ledger entry page, so you can now expose the pages as webservices and consume in PowerBI. We are planning to include dimensions in coming PowerBI packages.
Category: Reports and Business Intelligence
Business Central Team (administrator) on 5/17/2022 1:18:26 PM