Dear community,
I´ve been having some interesting issues in regards to the PBI Connection to dataverse tables. I will try to explain the situation as best as possible.
Background:
- I have a Dataverse table (T) in environment (E) that includes a column with "full" pictures. All of the information in T is saved with a Power App that requires a Pro-License.
- I connected T to a PowerBI file, where the pictures are shown. They are in "Picture-URL" format and can be seen on PowerBI Web version.
- Any user of the PowerBI who wants to see the pictures requires access to E where T is located. To do this, I´m providing them access to the Power App which writes in T. When opening the app, they get a prompt of accepting the connection to the databases.
- I created a Safety Role with reading access to T.
- We have enough licenses for E.
What happened:
- I first gave the users the safety role but still were not able to see the pictures. When trying to access the weblink of a specific picture, they got an "access denied" screen.
- I then created a new Safety Role with complete access to T, which also provided complete access to E and its apps.
- For some reason, having complete access to E enabled seeing pictures in the PBI report.
Problem:
Last week, One month after providing the users with the full-access safety role. Some users came back to me saying they could no longer see the pictures. They once again got an "acces denied" screen when trying to open a link to a specific pciture, as if the access had been removed. No changes had been made neither to the safety roles, nor to anything else.
I got the pictures back on by having the users re-open the app. And then go to the environment page where all the apps are listed.
After this, we refreshed PowerBI several times until the pictures were back.
Does anybody have any idea what could be happening? do accesses need refreshing? is the connection not stable?
Thanks,
