Forum Discussion
Power BI Service showin 2 data sources after changing it
Hi Anonymous ,
I interpret your deployment routine that way that you first publish the Power BI dataset to uat with the dev connection and afterwards you try to change the data source from dev to uat. The problem is that Power BI adds the second data source instead of changing it. I come up with two things that you could try:
1) Change your deployment routine to change data source before releasing to uat.
2) You could alias the data source (i.e. as sqldb) in your dataset. When changing the datasource from dev to uat you can use the alias to tell Power Bi to update the connection string of that explicit data source.
Here two blog posts about data sources. The first one is probably more relevant.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
GilbertQI'm using a single data source only.
As stated, the Issue is coming while changing the data source from dev to UAT through CI/CD Process.
My pbix file is connected to only one data source which points to the DEV database and has its workspace as well when this is getting published to my UAT workspace then it's a requirement that it should point towards the UAT database and when changing it from dev to uat I'm getting both sources under data source section on service.
Most Valuable ProfessionalHi Anonymous ,
I interpret your deployment routine that way that you first publish the Power BI dataset to uat with the dev connection and afterwards you try to change the data source from dev to uat. The problem is that Power BI adds the second data source instead of changing it. I come up with two things that you could try:
1) Change your deployment routine to change data source before releasing to uat.
2) You could alias the data source (i.e. as sqldb) in your dataset. When changing the datasource from dev to uat you can use the alias to tell Power Bi to update the connection string of that explicit data source.
Here two blog posts about data sources. The first one is probably more relevant.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/