Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Dbroomfield
New Member

Power BI Rest API with Service Account

Hi All,

I am trying to run the executeQueries Power BI Rest API but am running into issues. The API requires a Bearer token to be passed in, and I have found some guides on how to get these Bearer Tokens via a Service Principle. However, the dataset I am trying to query has Row Level Security enabled, which means I cannot use the Bearer Token I retrieved using a Service Principle to run my query as it is one of the limitations listed in the executeQueries guide I linked above. Any Ideo how I resolve this? I would like to use a Service account instead of a Service Principle to fetch a Bearer Token but I can't seem to find out how to retrieve one of these bearer tokens for an account instead of a Service Principle.

 

1 REPLY 1
lbendlin
Super User
Super User

You will have problems with the Service Account too unless it is included in the RLS roles.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.