PowerBI Filtering (API) through link Parameter Using Salesforce Embed

[Vedant]

Hello all,

I am trying to use an API connection and embed the PowerBI report over Salesforce. I am trying to filter the report using the URL filtering parameter. Unfortunately, this filtering is not working on the API side.

My queries are:

1. Can we use the GET API request of PowerBI that supports filter using URL parameters on api.powerbi.com

2. Do we have any PowerBI post API call to get the filter records from the PowerBI report.

Please guide.

[Anonymous]

Hi @Vedant ,

As far as I know, your needs seem to be unattainable. I can see if any other forum experts can provide you with some workaround.
Here is a list of some of the REST APIs that can be called in Power BI, you can check the left navigation of this link

Using the Power BI REST APIs 

You can also see about the use of URL filter：

Say you're working in Power BI Desktop. You want to create a report that has links to other Power BI reports, but you want to show only some of the information in the other reports. First, filter the reports using query string parameters and save the URLs. Next, create a table in Desktop with these new report URLs. Then publish and share the report.

Another use for query string parameters is for someone creating an advanced Power BI solution. Using DAX, they create a report that generates a filtered report URL dynamically based on the selection their customer makes in the current report. When customers select the URL, they see only the intended information. 

Filter a report using query string parameters in the URL 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.