8
To make sure when you embedd a Power BI report in a list page in Business Central, you need to add a filter for the Pk of the table, so the record in the list page is linked to the same record in the Power BI report.
However, the Power BI report may contain data from another, or multiple, companies.
Make it possible to also link the company in Business Central to the company used in the Power BI report.
Currently the documentation says:
"To make the data update to the selected record in the list, you add a filter to the report. The filter must include a field of the data source that's used to uniquely identify each record in the list. In developer terms, this field is the primary key. In most cases, the primary key for a list is the No. field."
Maybe instead of using the Pk and Company, the SystemId might be an alternative? That should be unique per record and company, right?
However, the Power BI report may contain data from another, or multiple, companies.
Make it possible to also link the company in Business Central to the company used in the Power BI report.
Currently the documentation says:
"To make the data update to the selected record in the list, you add a filter to the report. The filter must include a field of the data source that's used to uniquely identify each record in the list. In developer terms, this field is the primary key. In most cases, the primary key for a list is the No. field."
Maybe instead of using the Pk and Company, the SystemId might be an alternative? That should be unique per record and company, right?
STATUS DETAILS
Needs Votes
Business Central Team (administrator)