Performing query on Power Bi data set from Power Automate Flow triggered by Power Apps

(0) Share

Report

Posted on by MRBCODC

I am having and issue between 3 platforms communicating with each other Power Apps, Power BI & MS Flow

Environment Setup

• We have a Power App our planning fill in for cancelled, redirect, split and delayed orders etc

• We have set a BI report that collects data from snowflake hourly

• We have a flow that is called from power apps and gets data from Bi to prepopulate the form with SAP data (it is set to impersonate me in the flow at the Power Bi query step)

Everything works for myself (I am the owners of the Data set, Flow & power App) as we have overall access to everything needed for this

Users Access

• All planners have access to the power app and have no issues with access (access is given via Security Group)

• We have given access to them to the Power BI Dataset and Workspace via the same Security Group.

Issue

• Some users can run the flow and call data back and some users are getting errors in the run query from BI stage (if I use the same data in the query it works) here is a picture of the error the user sees and of what I am seeing in the flow

in app Error

Flow Error

I am unable to replicate the issue as for my account and a select few every thing works

I hope you can help

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Joel007 13 on at

Like (0)

Report
Copy link

Link copied!

I am having the exact same issue. I can get the data, other users can't, so this must be some authentication issue. So far I only tested with 1 user apart from me, she has access to the dataset, that's not the issue. I also tried the "Impersonate user" option but no difference. What caught my attention in the error message was -
"X-PowerBI-Error-Info": "GroupNotAccessible".

Did you ever find a solution?

Was this reply helpful? Yes No
MRBCODC 69 on at

Like (0)

Report
Copy link

Link copied!

Hi, yes I did. The user has to open the power Bi report once. This makes sure the user has a power bi account and also for some reason opening the report once allows the flow to bring back the data

Was this reply helpful? Yes No
Joel007 13 on at

Like (1)

Report
Copy link

Link copied!

Hi again, MRBCODC

Getting back to you as I found the solution for this issue:
THE PROBLEM: It works for some users, not for other, it's quite random. Instructing users one by one to open the Power BI report could create back and forth between the dev and users if you have many users, far from ideal. Besides the issue is elsewhere, try to tweak the Run only users setting in Power Automate.

SOLUTION #1 overriding role level security:
Set the connection used to access the Power Bi dataset to yours, this will connect to the data under the dev login and render the same result to all users.
This is achieving the same result as the Impersonate another user setting in the advanced section of the Run a query against a dataset step in Power Automate but, unlike that one, this actually works also for users facing the issue described here.

SOLUTION #2 retaining role level security:
I observed that changing the Run only users setting in Power Automate to your account and then back to run only user, somehow, fixes the issue too. The user who had the same error that you describe could now load the data this way in the app. But, for whatever reason, you need to elevate their access to write, not sure why but that's apparently needed to run queries, otherwise they are going to get this error:
After making that change in Run only users setting back and forth, the original error never came up again.

I went with solution #1 as I prefer to take care of security in the app, as I don't have so much control over accesses being granted to the PBI dataset. This way everyone can use the app with the same result.

Let me know if this worked for you.

Was this reply helpful? Yes No
RLouis 8 on at

Like (0)

Report
Copy link

Link copied!

Solution #1 worked perfectly. Thank you!!!

Was this reply helpful? Yes No
Guicord101 151 on at

Like (0)

Report
Copy link

Link copied!

Where can I find this option? "overriding role level security"

Could you walk me through it step by step? I didn't find this functionality in my flow

Was this reply helpful? Yes No
Joel007 13 on at

Like (0)

Report
Copy link

Link copied!

Hi Guicord101

You won't find that setting from my screenshot in the editor mode, you need to go a step back, click on Edit in the Run only users section in the bottom right corner. Also, please, note that this setting is only present for Instant flows, Automated flows don't offer this setting, as only Instant flows would run under the user's account by default. Automated flows always run under the creator's or a co-owner's account (that you can change in the edit mode, though).

Hope that helps.

Was this reply helpful? Yes No