Taking over a data model connected to a dataflow fails the refresh through an authentication issue

[Anonymous]

Hello PowerBI Gurus,

I use powerbi for data analytics with a coworker and we recently started using dataflows when we ran into this issue. 

-I set up a dataflow and connect to it with my desktop application using my credentials
- I build a model & report and publish it to the service (we split our models and reports using a script into two files)
-I push the dataflow, model & report from our DEV to UAT environment.

At this point everything works as intended and I can refresh the model properly. However, if my coworker takes over the datamodel specifically and tries to refresh, it will fail from an error. After looking into this, we have concluded it is caused because my coworker has different credentials which causes an authentication error and the only way we found to fix this is to open it up in desktop, authenticate there and republish / push only to have the same issue on the next take over. This is a very time consuming process for us and us we manage multiple different pipelines being able to take over from one another is crucial in managing them. It would be greately appreciated if someone knows of a workaround to this issue.

Thanks in advance for any help that follows!

[dmacdonald]

Because POwerBI was designed for a single user to do everything.

Working as a team in PowerBI is a nightmare of trouble.

It's been that way for a long time, so I suspect some deep undelying structure issues that cause this.

The best solution we have found is to create a single user account and doo all the work under that account.

Of course that creates a tracking and security nightmare, but it allows production reporting to continue without the regular firedrills required if anything is "Taken over".

They should warn you that taking over a dataset will potentially create hours of troubleshooting and work and should never be done in a production environment.

[Anonymous]

Main part of the error code: 
aadsts135010: userprincipal doesn't have the key id configured

[SaiTejaTalasila]

Hi @Anonymous ,

You can get a service account from your entra team and you can manage all your dataflows,datasets and apps through that account.

You can check whether your colleague have access to all datasources or not.As per my understanding if you are using git multiple users can't edit same item in your report at same time.

I hope it will be helpful.

Thanks,

Sai Teja