Refresh pbix with multiple datasource.

[Anonymous]

I have a pbix with datasource as Redshift and I am fetching 2 tables "Sales" and "Profit" from datasource.

Now, there are 3 different clusters(dev, qa, uat) in reshift so, what I am doing is creating a parameter table in all the clusters and providing the source connection string in that parameter table 

Then, fetching 3rd table as parameters table in the pbix file.

Now, I have 3 tables in pbix file sales, profit, parameter.

Now I am creating a parameter in pbix file having connection string from parameter table.

And, replacing the connection source string with query  parameter for all the 3 tables.

But when I publish this pbix file to power BI service it is not allowing me to refresh the dataset.

Because parameter table is coming from dev and other 2 tables are coming from qa.

I Really spent efforts on this but not found any solution for this.

Pls help me out with this.

Thanks in advance.

Ansh

[v-yalanwu-msft]

Hi， @Anonymous ；

Can you share the screenshots what is the reminder that pbix cannot be refreshed? Another point, is it refreshed on the service? If so, you need to edit different credentials for multiple data sources.

https://powerbi.microsoft.com/pt-br/blog/announcing-support-for-amazon-redshift-reports-in-the-power-bi-service/

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The PBIX is working fine on desktop but it is giving error on power bi service.
I have setup gateway as well with the right credentials.

Still it gives the bellow error :
table references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.