Filter report before load

[andresud]

I'm trying to get the report filtered before loaded. I tried two aproaches:

Filtered in the URL like this: URL/?filter=table/column+in+(%27USERID%27)'; and Javascript filter: const filter = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "tableName", column: "columnName" }, operator: "In", values: ["USERID"] };

None of them worked, any ideas?

[ltobiasg]

@andresud were you able to come up with a solution? I'm facing the problem now. Thanks

[cplewis]

I'm also trying to figure out how to do this. In my case, I want to filter the Power BI Visual by Account.Id. I've modified the LWC so that it receives the account Id from the record page I've placed the component on. At I modified the Apex Controller to pass a filter parameter on the Rest API URL, but that didn't work.

I was able to get it to work by modifying the JS file in the LWC. I added this filter variable const basicFilter = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "Payment Gaps", column: "Customer__c" }, operator: "In", values: [this.recordId] };

and referenced it in the config var config = { type: 'report', id: reportId, embedUrl: embedUrl, accessToken: token, tokenType: 1, filters: [basicFilter], settings: { panes: { filters: { expanded: false, visible: true }, pageNavigation: { visible: false } } } }; (sorry for the lack of formatting) Now when I view that embedded report, it correctly shows the data only for that customer.

[SureshKX25]

@cplewis I have a similar requirement to filter the Power BI Report by Account Id. I modified the JS file with the filter like above. Modified the apex class to filter the url String urlGetReport = 'https://api.powerbi.com/v1.0/myorg/groups/' + WorkspaceId + '/reports/' + ReportId + '/?$filter ='+ basicFilter; Getting a bad request error. What am I missing here. Any ideas.