Reply
surendray0218
New Member
Partially syndicated - Outbound

Data from SharePoint list page

Hope I can get some support to resolve the issues that I'm facing.

 

Pulling data from SharePoint Risk Log. Our risk log has Risk Type with values Risk and Opportunity. Based on user selection, values in Status changes. When I pull the data to PowerBI, actual values are not showing up in status. See the screen shot below. How can I see the actual values.

surendray0218_1-1644720590302.png

 

 

3 REPLIES 3
v-zhangti
Community Support
Community Support

Syndicated - Outbound

Hi, @surendray0218 

 

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.

surendray0218
New Member

Syndicated - Outbound

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.

lbendlin
Super User
Super User

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)