Data from SharePoint list page

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Thanks for response. The status column is caluculated/ condition based. I.e, if user select the Risk Type, then values in the Status Changes which are only applicable to risk i.e., Active, Accepted, Realized,  and closed. If user Selects Opportunity the values in Status colum changes to Exploit, Share, Enhance, Ignore.

Currently when I pull the data into PowerBI, not able to see the actual values. If I can see the values then I can use Status column as filter on PowerBI report. Any guidance is greatly appreciated.

Hi, Anonymous 

Considerations for quickly creating a report from a SharePoint list or library in Power BI Services：

Currently, some complex column types in SharePoint will show up as [Record]s or [List]s within the report. We’re working on updating the experience so these column values match what you see in the list or library.

This is the relevant document, hope to help you:

https://docs.microsoft.com/power-bi/create-reports/service-quick-create-sharepoint-list 

If your status column can be determined by the values of other columns, it is recommended that you use the Dax function.

Best Regards,

Community Support Team _Charlotte

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