Forum Discussion
Can't use a SPN in a PowerBi dashboard to access SharePoint lists
Hoping you can help with an ongoing issue I have. I have a PowerBi dashboard I built using regular account to fetch some SharePoint lists and uploaded it to PowerBi for others to view Now in Power...
This behavior is not a product defect. Power BI service principals cannot rely solely on the Sites.Read.All permission to access SharePoint lists. Instead, the service principal must be granted the Sites.Selected permission and explicitly assigned the appropriate role at the individual SharePoint site level. Without this site-specific assignment, OAuth token requests will consistently fail, even if tenant-wide permissions have already been consented.
Referring below that may help for your case:
Solved: Connect SharePoint List using Service Principal fr... - Microsoft Fabric Community