Can't Fix Power BI Embedded Issue After User Migration

[SteveH81]

Hi,

We've just had to do some azure tenancy work.  And now my PowerBI embedded solution isn't working.

Everything was working great.  But had to create a new user for publishing the reports.  I've published the reports.  I've linked the on site gateway to the new user.  I've assigned access to the app and the serivce principal to the data connections, data sources and the new work space.  I've updated the workspace, report and dataset ids in my app.

All is working until I try to embed the report, which requires me to change ownership of the dataset, to the service principal so I can parameterise the query.  At which point it breaks...

So the liniage changes from this when I publish, and my publishing owner owns the report:

To this, once I've tried to embed it and the service principal has taken owner ship.

Like i said, this was all working wonderfully... I've been through all the tutorial again, looking for permissions e.t.c. that I've missed.

Any suggestions on what I've overlooked?

Kind Regards,

Steve H

[SteveH81 · Accepted solution]

So I had to drill into the API for service principal, but I discovered that my service principal had access to an orphaned data gateway.  I've looked and can't find it anywhere in the power bi website.  

So I had to call Datasets.BindToGateway to specify which of the available gateways to use.  Where before I only had one, I now have more, so must explicitly set it.