Forum Discussion
Different data sources with the same visualisation in one page
If i read you correctly, you want an easy way to point to a different environment but with identical schema, such as repoint a report from dev to UAT to Production data sources.
There is no dropdown, but the dropdown under the "Edit Queries" button allows editing of data sources. In here you can change various parameters, depending on what options the source allows you to alter.its also possible to use a parameter to change connection, which may help provide what you require, have a look at this article:
https://community.powerbi.com/t5/Community-Blog/Using-the-Power-BI-Service-Parameters-to-change-connection/ba-p/392016
Post PatronAnonymous
The report depends on the underlying schema. If its looking for a TableA.ColumnA, but this doesnt exist after you point to a new environment, the report will break.
There are probably ways to work around this in some cases, but its not recommended. reports really need a stable schema.
if the only thing that changes are columns or tables that you are not using, then you should have no problems.
Hi wilson_smyth in my case Schema name and server name are different but the columns are identical in the table. Only thing change is data (rows). One server+schema having less data but another having more data.
on my UAT environment i am using a PowerBifile1 with Server1+schema1. But,
on my Prodcution environment i am using same PowerBifile1 with server2+schema2.
What I am able to do is change the Server1/2 name using parameters. But I am also looking for solution that change schema name as well some how.
I use function to get data not direct tables. please see example below how my query looks like:
SELECT * FROM "SCHEMA1"."FN_Name"();
Note: Currently I open my powerbi file and change the schema manuly that is lot of effort if i have suppose 100 tables.
- wilson_smyth
in that case, when you mean database schema used to organize objects and for security, yes, that can be parameterized, i.e. create a parameter and reference it in your power query.
there are some details in this post on the community.
wilson_smyth I think I was making it complicated by mentioning schema change. What i simply want is to pass parameter in to my query. Is this make sense?