Power BI Rest API with Service Account

[Dbroomfield]

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.

[lbendlin]

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