Forum Discussion
Data soucre credentials lost when dataset owner changes
Hi everyone,
I noticed a strange behavior in the gateway / dataset settings in Power BI Service:
We have some reports with a scheduled refresh via enterprise gateway.
Now if anyone takes over the dataset, the dataset mapping for the gateway disappears and thus the refresh doesn't work any more until the new owner enters the correct mapping again.
Until now that wasn't a big problem, since the dataset owner doesn't change frequently.
However currently we are testing deployment pipelines, and with those, only the dataset owner can deploy a new report version to the next stage.
Is this a bug or is there any way to circumvent this behavior? Especially with deployment pipelines, my expectation is that after deployment the reports just work in production, without having to do some addition manual settings like updating the gateway mappings.
Hi, IMett
When other admin "take over" your dataset, he will inevitably need to reset the configuration settings including credentials or scheduled refresh, and so on.
It is the same not only in an pipeline deployment environment, but also in an ordinary workspace. At present, I have not found an effective solution, although it does bring a lot of troublesome operations.Related ideas :
https://ideas.powerbi.com/ideas/idea/?ideaid=e5831039-74ad-43af-bd14-d8347b7fa571
https://ideas.powerbi.com/ideas/idea/?ideaid=2e2be0fd-6717-4814-9066-1e045491efad
About who can delpoy to reproduction,please refer to this document.
Best Regards,
Community Support Team _ Eason
4 Replies
Hi, IMett
When other admin "take over" your dataset, he will inevitably need to reset the configuration settings including credentials or scheduled refresh, and so on.
It is the same not only in an pipeline deployment environment, but also in an ordinary workspace. At present, I have not found an effective solution, although it does bring a lot of troublesome operations.Related ideas :
https://ideas.powerbi.com/ideas/idea/?ideaid=e5831039-74ad-43af-bd14-d8347b7fa571
https://ideas.powerbi.com/ideas/idea/?ideaid=2e2be0fd-6717-4814-9066-1e045491efad
About who can delpoy to reproduction,please refer to this document.
Best Regards,
Community Support Team _ EasonThis was discussed in yesterday's (excellent) Power BI Dev Camp session with Ted Pattison.
https://aka.ms/PBIWebinar09242020
Thx for the Dev Camp session link. I think, this is too deep for me so far. Currently we only use the frontend clients for publishing and updating reports.
We have a team of people working on BI reports and this has become problematic. Doesn't make any sense that the data mappings are lost especially when the people working on the models have permissions to use the Gateways. This is an oversight that should be addressed.
