Dynamics Community Forum Thread Details

Getting dimensions into Power BI

Hi,

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

Quick Links

Leaderboard