Pass Parameters to Report Embedded in SAP C4C

[Seth_Brundle]

Hi,
I'm trying to create a PBI report that will be embeded inside a SAP C4C page.

When a user is looking at an individual customer on the C4C page, it should load the embedded PBI report which will show additional data on that customer. it will effectively filter automatically depending on the C4C customer being viewed.

However, the nature of passing parameters from C4C is giving me headaches.

Whilst passing a parameter via a querystring using the following formats work (and filters my report) whilst viewing the PBI report standalone from app.powerbi.com...

PowerBI_URL?filter=C4C_CUSTOMER eq '123456' 

PowerBI_URL?filter=TABLE/COLUMN eq '123456' 

However, the option to create the querystring within C4C is a form of GUI and it does not like the querystring required for PBI - as far as C4C is concerned, the querystring filter is named "filter" and its value is "C4C_CUSTOMER eq '123456'" 

I need some way of simply passing a Customer ID to PBI.
I've looked at creating a Parameter filter but couldn't seem to get that to work.
I'm not sure if DAX can pull a bespoke querystring value e.g. ?MyC4CID = xxx

Is there an easy step-by-step guide to dig me out of a hole?

Thanks. 

[Seth_Brundle]

In the end and as per your advice, I went with a HTML page containing an iframe. The page contains javaScript which collects a customer ID from its querystring e.g. page.html?customerID=123456 and loads my PBI report using PowerBI_URL?filter=TABLE/COLUMN eq '123456'.

It works as expected so everyone is happy and I now look great 😎

[v-sgandrathi · Accepted solution]

Hi @Seth_Brundle,

Thank you for sharing the detailed background. Integrating Power BI reports with third-party platforms like SAP C4C can be challenging, especially when it comes to creating dynamic URLs.

Power BI does allow query string filters using the ?filter=Table/Column eq 'value' format. However, SAP C4C’s GUI-based tool treats the whole filter as a string, which disrupts the syntax Power BI expects. This often means that passing filters through query strings from C4C doesn’t work properly.

The most effective workaround is to use the Power BI JavaScript SDK to apply filters dynamically. If you have control over the embedding in C4C (such as using an iframe with custom HTML/JavaScript), you can extract the Customer ID and apply it with JavaScript, bypassing URL manipulation and ensuring filters work as intended once the report loads.

If your setup uses Power BI Embedded with a service principal or master user, you can pass the Customer ID during embed token generation using the EffectiveIdentity field. This way, Power BI applies dataset-level filtering automatically, even for users who aren’t Microsoft-authenticated.

Currently, Power BI can’t read custom query string parameters like ?MyC4CID=123456 unless you handle them in your application logic. If you’re limited to SAP C4C’s GUI for URL setup, this approach won’t be reliable.

Please find below the official  Ms document for your reference:
Edit SAP variables in Power BI - Power BI | Microsoft Learn

Thank you and continue using Microsoft Fabric Community Forum.

[v-sgandrathi]

Hi @Seth_Brundle,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you.