Power BI Service showin 2 data sources after changing it

[abhi_PBIUser]

Dear Team,

I'm doing CI/CD and after using power BI Action to update the data source from DEV to UAT, I saw both dev and uat data sources were present in the dataset which is weird.

Incremental refresh is set up in this dataset but I don't think it should cause any errors.

Please find the attached SS:

[GilbertQ]

Hi @abhi_PBIUser 

I would suggest only making sure to have a single dataset in each of your datasets to ensure that it can only connect to the relevant source. And this will also ensure that the data source can successfully connect?

[abhi_PBIUser]

@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.

[tackytechtom · Accepted solution]

Hi @abhi_PBIUser ,

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.

https://powerbi.microsoft.com/en-us/blog/using-xmla-endpoints-to-change-data-sources-in-a-power-bi-d...

https://www.tackytech.blog/how-to-automate-the-management-of-custom-partitions-for-power-bi-datasets...

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/