Microsoft Power Bi - Filtering in back-end

Question

Hello. I am starting to study Microsoft Power BI now, and would like help on a question. First I created an excel as a data source:

Then I created a data set and a report:

All right so far. I’m using the sample solution that Microsoft provides on https://app.powerbi.com/embedsetup. Now I’d like to filter back-end that report.

Example: When it is called in my application, I pass it a back-end ID, and it already Filter the report showing it only with the pertinent information that ID.

In the case of the above image, it would display ONLY the information of Id 5. Without showing the others that appear there without being selected.

Can anyone help me? Thank you.

ADDING INFORMATION: The link that Powerbi Embed generates in the back end is different, and the filter that we tested in the answer below does not work. Any hint of how to solve?

No EmbedService temos o código:
// Generate Embed Configuration.
m_embedConfig.EmbedToken = tokenResponse;
m_embedConfig.EmbedUrl = report.EmbedUrl;

I was able to solve this problem by changing the URL creation in Embedservice, adding:

?rs:embed=true&filter=table/column eq 'filtervalue'

Answer 1

To do this you will need to complement your URL with the following add-on:

..URL?filter=Table/Field eq 'value'

Something more or less like this:

Important remarks:

• Table (Table) and field (Field) items are CASE SENSITIVE, the value is not;

• Fields that do not appear in the report view can still be filtered.

Links that can help you with your questions:

Filter a report using query string Parameters in the URL

Easily embed Secure Power BI Reports in your Internal Portals or websites

How to pass Powerbi Embedded Report

To find your table name, just look at the FIELDS menu in the right corner of your powerbi when it’s in the tab that shows your dashboard.

In this example we have 4 tables:

Answer 2

The link that Powerbi Embed generates in the back end is different, and the filter we tested above doesn’t work. Any hint of how to solve?

In Embedservice we have the code:

// Generate Embed Configuration.
m_embedConfig.EmbedToken = tokenResponse;
m_embedConfig.EmbedUrl = report.EmbedUrl;