Embed Report in SharePoint and Dynamically Filter based on SharePoint Site

[russell80]

Hi, I have a SharePoint site to manage projects, each time a new project is started, a new site is created for the project based off a template. In the new project site, I want to embed a power BI report (as part of the template) to show data for that project (the report currently holds data for all projects but can easilly be filterted). I can get as far as embedding the report in the site, and using the Power BI Developer Sandbox, I can set a report filter using a predefined filter value for the project code like below. But where I have gotten stuck is I want to be able to pass the project code from the SharePoint site and use it as the value in the filter. Not sure it's even possible though.

const basicFilter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "Projects",
column: "Project Code"
},
operator: "In",
values: ["123456"],
filterType: models.FilterType.BasicFilter,
requireSingleSelection: true
}

await report.updateFilters(models.FiltersOperations.Add, [basicFilter]);

[v-jianboli-msft · Accepted solution]

Hi @russell80 ,

The Get a site resource API Could retrieve properties and relationships for a site resource. A site resource represents a team site in SharePoint.

Please check if this API could help you.

For more details, please refer to:

Get a SharePoint Site - Microsoft Graph v1.0 | Microsoft Learn

Best Regards,

Jianbo Li

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