Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
You will have problems with the Service Account too unless it is included in the RLS roles.
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |