Filter Power BI Report on a Item in the item list.

(0) Share

Report

Posted on by Knofan

Hey

Im writing a report that display information about an Item. The report will be at the side of the Item list inside of BC. See image:

4532.bc1.JPG

Is it possible to filter this report on based of the selected item in the Items list?

Regards

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Steven Renders 5,666 Moderator on at

Like (2)

Report

RE: Filter Power BI Report on a Item in the item list.

No, not at this moment. Hopefully that will become possible in the future...

Was this reply helpful? Yes No
David Guimaraes 5 on at

Like (0)

Report

RE: Filter Power BI Report on a Item in the item list.

Hi,

What if I have the same Item No. in differente companies in the Database?

Is there a way that the embebbed report show only the data from the Current Company.

Best Regards,

David

ps: It is my first entry on the Dynamics 365 Business Central Forum .

Was this reply helpful? Yes No
YUN ZHU 92,161 Super User 2025 Season 2 on at

Like (0)

Report

RE: Filter Power BI Report on a Item in the item list.

Thanks for the update, I'll test it out next week.

Was this reply helpful? Yes No
Knofan 49 on at

Like (0)

Report

RE: Filter Power BI Report on a Item in the item list.

Iam sorry Steven, i did not refresh my page before i posted. I did not see your answer. But i have changed so that you earned the checkmark any way :)

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,666 Moderator on at

Like (0)

Report

RE: Filter Power BI Report on a Item in the item list.

That's exactly what I suggested ;-)

Was this reply helpful? Yes No
Verified answer

Steven Renders 5,666 Moderator on at

Like (1)

Report

RE: Filter Power BI Report on a Item in the item list.

Yes, that's possible.

You simply need to add a report filter in the Power BI report that contains the Item No field:

Display Custom Power BI Reports - Business Central | Microsoft Learn

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.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,666 Moderator on at

Like (0)

Report

RE: Filter Power BI Report on a Item in the item list.

As Zhu mentioned its not possible you can also set filters on particular fields, pages etc. but not on report.

Was this reply helpful? Yes No
YUN ZHU 92,161 Super User 2025 Season 2 on at

Like (0)

Report

RE: Filter Power BI Report on a Item in the item list.

Hi, as far as I know, this cannot be done. When selecting a Report, you can control which Report to open, but the system does not add parameters for Power BI filter conditions. This is controlled within Power BI, unless you add a Power BI report for each Item. . . .

Hopefully other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No