Showing data within from SharePoint Lists

[ak8598]

Hi,

I'm building a dynamic Power BI Report based off data collected in SharePoint Lists for my organisation. I want to be able to only show relevant fields that are filled out in the SharePoint Lists within my report. 

For example, there are many fields that collect data within my SharePoint List, but not all fields are mandatory, so I would like to only provide visualisations in my Power BI Report for the fields that are filled out by the user within the SharePoint List. Is there a way to dynamically set that up?

Additionally, the aim is to create a Power BI Report each time a new item is added to said SharePoint List. Is there a way I can use Power Automate to ensure only one list itme is visualised per report?

Thanks!

[lbendlin]

"the aim is to create a Power BI Report each time a new item is added to said SharePoint List"

So if 1000 items are added to the sharepoint list you want to create 1000 reports?

[ak8598]

The idea is that it's a crisis monitoring dashboard, so one aspect of the solution is to be able to generate a one-pager visualisation from each newly added item to the SharePoint list. 

Whichever office of ours around the globe is impacted by a crisis, would need to fill in and update the same item that they filled in the first time, which would update the specific Power BI report that was created from their first item added within the SharePoint list.

For example, say there's a cyber attack in our office in Milan, the office would fill out a template describing the situation through the SharePoint list we've built and would periodically update it as and when more information comes in. A Power BI report would ideally be created for that first instance when they added to the SharePoint list and would then continously be updated when and if the original item is edited.

[lbendlin]

You cannot create standard Power BI report pages on the fly. You may need to look into Power BI Embedded functionality for that.

You can create individual reports on the fly but there is a lot (A LOT) of plumbing that needs to happen behind the scenes, with many things only achievable via API calls. You're looking at some serious development work.