Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
We need to be able to change the datasource
- in desktop without apply,
- on the dataset in app.powerbi.Com (not in desktop).
Currently, to my knowledge, it is not possible to change a datasource without having access rights to the source.
In some scénario, it is required the PowerBI developer does not have acecss to the production source, for example when the power bi connecto only support the Storage account master key as a credentail (obviously we can't give developers the prodcution stoage account master key). We develop on a non production data source, and then we need to change the source to deploy in production where we can connect the source to a data gateway where the datasource is configured and where we have the rights to use the datasource (access security is delegated on the gateway datasource).
Have you considered using Deployment Pipelines?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 16 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 42 | |
| 40 | |
| 40 | |
| 40 |