Share
Report
5Hi,
I am trying to create a number of reports in Power BI using Business Central data. I wasn't sure whether to post this here or in the Power BI forum but decided to start here.
I need to report on Sales by Dimension by month ( and later various other things by dimension too )
However, I can't see a way of getting the dimension data into Power BI. I have the Dimensions and DimensionValues tables and I also have the GeneralLedgerEntries and SalesInvoices tables but these don't provide the dimension details at transaction level.
I suspect that what I need is in either the DimensionSetLines or SalesInvoiceLines tables, would I be right?
Unfortunately Power BI does not let me import those tables, giving the following error messages respectively:
DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (You must get to the parent first to get to the dimension set line. CorrelationId: 764c75fa-39e8-41b9-b70d-82642d05a9aa.)
Details:
DataSourceKind=Dynamics365BusinessCentral
DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (You must specify an Id or a Document Id to get the lines. CorrelationId: 5ae5e9ba-0db6-43ba-a47c-587817c454e8.)
Details:
DataSourceKind=Dynamics365BusinessCentral
Can anyone guide me as to how to resolve this?
Please bear with me as I have limited experience with Power BI and even less with MS Dynamics.
Many thanks, Bruce
All responses (
Answers (
